Re: Server 8.0 is extremaly slow

[Frederic Descamps]

Hi Rafael,

On the slow MySQL 8, could you run the following statement and share the with me the output (if there is some confidential data, don't forge to anonymize it in the query sample output):

SELECT schema_name, format_time(total_latency) tot_lat,
exec_count, format_time(total_latency/exec_count) latency_per_call,
query_sample_text
FROM sys.x$statements_with_runtimes_in_95th_percentile AS t1
JOIN performance_schema.events_statements_summary_by_digest AS t2
ON t2.digest=t1.digest
WHERE schema_name NOT in ('performance_schema', 'sys')
ORDER BY (total_latency/exec_count) desc \G

Thank you.