Not the answer you need?
Register and ask your own question!

pmm client QAN

geoiiigeoiii EntrantCurrent User Role Beginner
I am running the latest version of the client and server and I have been noticing that on some of my mysql servers that the CPU load is going high - and it seems to be related to this slow query


​​​SELECT COALESCE(SCHEMA_NAME, ''), COALESCE(DIGEST, ''), COUNT_STAR, SUM_TIMER_WAIT, MIN_TIMER_WAIT, AVG_TIMER_WAIT, MAX_TIMER_WAIT, SUM_LOCK_TIME, SUM_ERRORS, SUM_WARNINGS, SUM_ROWS_AFFECTED, SUM_ROWS_SENT, SUM_ROWS_EXAMINED, SUM_CREATED_TMP_DISK_TABLES, SUM_CREATED_TMP_TABLES, SUM_SELECT_FULL_JOIN, SUM_SELECT_FULL_RANGE_JOIN, SUM_SELECT_RANGE, SUM_SELECT_RANGE_CHECK, SUM_SELECT_SCAN, SUM_SORT_MERGE_PASSES, SUM_SORT_RANGE, SUM_SORT_ROWS, SUM_SORT_SCAN, SUM_NO_INDEX_USED, SUM_NO_GOOD_INDEX_USED FROM performance_schema.events_statements_summary_by_digest WHERE DIGEST IS NOT NULL AND LAST_SEEN > NOW() - INTERVAL 9223372036 SECOND:



It takes a long time to run (~60 seconds), is this to be expected or is there some known issue? Or am I missing something on my end?

Thanks

Comments

  • PeterPeter Percona CEO Percona Moderator Role
    What MySQL version are you running ? What is your
    performance_schema_digests_size variable value ?
This discussion has been closed.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.