search

shatteredsilicon / ssm-submodules

GNU Affero General Public License v3.0
0 stars 2 forks source link

QAN + query_source=performance_schema + MySQL 8.0.x seems to not collect individual query timings. #231

Closed gordan-bobic closed 4 months ago

gordan-bobic commented 5 months ago

With these enabled:

UPDATE performance_schema.setup_consumers SET ENABLED = 'YES' WHERE NAME LIKE '%statements%';
UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME LIKE 'statement/%';

we get queries and examples, and things mostly work, but avg times return as 0 for all queries. Is this due to a bug/regression/change in recent MySQL 8? Is there something we can do to make it work?

gordan-bobic commented 5 months ago

Note - this could be an Azure bug, as Azure's built in monitoring also seems to show no query time.