dba:mysql:mysql_basic_queries
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
dba:mysql:mysql_basic_queries [2022/02/11 11:36] – external edit 127.0.0.1 | dba:mysql:mysql_basic_queries [2022/02/17 17:57] – [per user] dodger | ||
---|---|---|---|
Line 48: | Line 48: | ||
+ | ====== Memory ====== | ||
+ | ===== Global summary ===== | ||
+ | |||
+ | <code sql> | ||
+ | | ||
+ | sys.format_bytes(current_number_of_bytes_used) curr_alloc, | ||
+ | count_alloc, | ||
+ | sys.format_bytes(sum_number_of_bytes_alloc) total_alloc, | ||
+ | count_free, | ||
+ | sys.format_bytes(sum_number_of_bytes_free) total_free | ||
+ | FROM performance_schema.memory_summary_global_by_event_name; | ||
+ | </ | ||
+ | |||
+ | |||
+ | ===== memory by event ===== | ||
+ | |||
+ | <code sql> | ||
+ | SELECT EVENT_NAME, | ||
+ | COUNT_ALLOC, | ||
+ | COUNT_FREE, | ||
+ | SUM_NUMBER_OF_BYTES_ALLOC, | ||
+ | SUM_NUMBER_OF_BYTES_FREE | ||
+ | FROM performance_schema.memory_summary_global_by_event_name | ||
+ | where count_alloc> | ||
+ | ORDER BY count_alloc | ||
+ | ; | ||
+ | </ | ||
+ | |||
+ | ===== per user ===== | ||
+ | <code sql> | ||
+ | | ||
+ | current_count_used AS curr_count, | ||
+ | sys.format_bytes(current_number_of_bytes_used) curr_alloc, | ||
+ | count_alloc, | ||
+ | sys.format_bytes(sum_number_of_bytes_alloc) total_alloc, | ||
+ | count_free, | ||
+ | sys.format_bytes(sum_number_of_bytes_free) total_free | ||
+ | FROM performance_schema.memory_summary_by_user_by_event_name | ||
+ | where current_number_of_bytes_used> | ||
+ | ORDER BY current_number_of_bytes_used DESC; | ||
+ | </ | ||
dba/mysql/mysql_basic_queries.txt · Last modified: 2024/09/17 09:47 by dodger