How can I profile queries with MariaDB using ANTS Performance Profiler?

davidfanthony

I noticed on the ANTS Performance Profiler Overview page:

https://www.red-gate.com/products/dotnet-development/ants-performance-profiler/

The following: 
Enhanced data access profiling, with support for SQL Server, Oracle, MySQL, MariaDB, and PostgreSQL

I'd like to profile MariaDB in my app (it's the database), can someone direct me to a "how to" or otherwise provide guidance?

Russell D

With some basic analysis, it looks like we have some instrumentation specific for MySQL. I've not actually got the ability to test with MariaDB so really I'd just give it a go using normal sql profiling: https://documentation.red-gate.com/app/setting-up-and-running-a-profiling-session/profiling-sql-queries. I would expect the calls to show up here as they would with sql/oracle.

davidfanthony

Thanks Russell D for the response.  I followed the instructions on that page and ran a profiling session:

".NET executable"
Profiling mode: "Line-level & method-level timings"

Checked "Enable SQL query profiling"

...but wound up with the following on the "Database calls" tab:

"No SQL queries were recorded for the currently selected time period.  If your application is making database calls, run a new profiling session and enable SQL query profiling."

I even drilled-down into the call tree where I knew a query was being issued: 

MySqlConnector.Core.TextCommandExecutor.ExecuteReaderAsync(...

We are using the Pomelo Entity Framework driver with MariaDb:
GitHub - PomeloFoundation/Pomelo.EntityFrameworkCore.MySql: Entity Framework Core provider for MySQL and MariaDB built on top of MySqlConnector

Is there something special I'm missing besides checking "Enable SQL query profiling?"

Russell D

No I don't think so. I'll forward this on to the .net team now.

Jessica R

Hi there,

Unfortunately, we currently only support the default MySql ADO.NET provider (MySql.Data.dll), while Pomelo.EntityFrameworkCore.MySql uses MySqlConnector provider (MySqlConnector.dll). We don't have any ETA at the moment, but we've created an enhancement request for it with reference PP-4282 and will post here if there is any update.

madffm

Hi,

Today we ran into the same problem.
Are there any news on this topic?

Thanks
Matthias

madffm

Hi,
We ran into the same problem.
Are there any news on this topic?

madffm

Hi,

Today we ran into the same problem.
Are there any news on this topic?

Thanks
Matthias