Differences

This shows you the differences between two versions of the page.

--- dba:mysql:mysql_basic_queries [2022/02/11 11:12] – ↷ Page moved from mysql:mysql_basic_queries to dba:mysql:mysql_basic_queries dodger
+++ dba:mysql:mysql_basic_queries [2022/02/17 17:55] – [memory by event] dodger
@@ Line 48: / Line 48: @@
+====== Memory ======
+===== Global summary =====
+<code sql>
+ SELECT 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_global_by_event_name;
+</code>
+===== 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>1
+ORDER BY count_alloc
+;
+</code>
+===== per user =====
+<code sql>
+ SELECT IFNULL(user, 'mysqld_background') AS user,
+        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<>0
+  ORDER BY current_number_of_bytes_used DESC;
+</code>