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

• 
  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.
  

  Russell D December 21, 2020 08:34

  - 0 +
• 
  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?"

  davidfanthony December 21, 2020 22:20

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

  Russell D December 22, 2020 11:09

  - 0 +
• 
  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.
  

  Jessica R December 23, 2020 21:03

  - 0 +
• 
  Hi,

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

  Thanks
  Matthias
  

  madffm May 13, 2024 12:51

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

  madffm May 14, 2024 11:40

  - 0 +
• 
  Hi,

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

  Thanks
  Matthias
  

  madffm May 15, 2024 08:50

  - 0 +

Add comment

Please sign in to leave a comment.