Ciberterminal Wiki

User Tools

Site Tools

Trace:
dba:mysql:mysql_basic_queries

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
dba:mysql:mysql_basic_queries [2022/02/17 17:54] – dodgerdba:mysql:mysql_basic_queries [2022/02/17 17:57] (current) – [per user] dodger
Line 49: Line 49:
  
 ====== Memory ====== ====== 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 ===== ===== 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>0
   ORDER BY current_number_of_bytes_used DESC;   ORDER BY current_number_of_bytes_used DESC;
 </code> </code>
dba/mysql/mysql_basic_queries.txt · Last modified: 2022/02/17 17:57 by dodger