dba:mysql:mysql_basic_queries
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
dba:mysql:mysql_basic_queries [2022/02/17 17:54] – dodger | dba:mysql:mysql_basic_queries [2022/02/17 17:57] (current) – [per user] dodger | ||
---|---|---|---|
Line 49: | Line 49: | ||
====== Memory ====== | ====== 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 ===== | ===== memory by event ===== | ||
Line 73: | Line 86: | ||
sys.format_bytes(sum_number_of_bytes_free) total_free | sys.format_bytes(sum_number_of_bytes_free) total_free | ||
FROM performance_schema.memory_summary_by_user_by_event_name | FROM performance_schema.memory_summary_by_user_by_event_name | ||
- | where current_number_of_bytes_used<>0 | + | where current_number_of_bytes_used> |
ORDER BY current_number_of_bytes_used DESC; | ORDER BY current_number_of_bytes_used DESC; | ||
</ | </ |
dba/mysql/mysql_basic_queries.1645120440.txt.gz · Last modified: 2022/02/17 17:54 by dodger