Skip to content

Instantly share code, notes, and snippets.

@ylacancellera
Created January 20, 2022 16:23
Show Gist options
  • Save ylacancellera/29fef4f332e254532d7f81565f628557 to your computer and use it in GitHub Desktop.
Save ylacancellera/29fef4f332e254532d7f81565f628557 to your computer and use it in GitHub Desktop.
performance-schema-instrument='memory%=COUNTED'
# Top 15 events currently eating ram
mysql> SELECT EVENT_NAME, CURRENT_NUMBER_OF_BYTES_USED FROM performance_schema.memory_summary_global_by_event_name ORDER BY CURRENT_NUMBER_OF_BYTES_USED DESC LIMIT 15;
# Top 15 events that allocated the most since restart
mysql> SELECT EVENT_NAME, HIGH_NUMBER_OF_BYTES_USED FROM performance_schema.memory_summary_global_by_event_name ORDER BY HIGH_NUMBER_OF_BYTES_USED DESC LIMIT 15;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment