memory_summary_by_account_by_event_name 详解

系统表介绍

memory_summary_by_account_by_event_name 记录了事件对内存的使用,按照访客与事件进行分组统计.

列名	含义
USER	用户名
HOST	客户端IP
EVENT_NAME	事件名
COUNT_ALLOC	内存分配次数
COUNT_FREE	内存释放次数
SUM_NUMBER_OF_BYTES_ALLOC	总内存分配大小
SUM_NUMBER_OF_BYTES_FREE	总内存释放大小
LOW_COUNT_USED	当前持有的内存块数量
CURRENT_COUNT_USED	持有内存块的低水位线
HIGH_COUNT_USED	持有内存块的高水位线
LOW_NUMBER_OF_BYTES_USED	持有内存字节数的低水位线
CURRENT_NUMBER_OF_BYTES_USED	当前持有内存的数量
HIGH_NUMBER_OF_BYTES_USED	持有内存字节数的高水位线

实例

mysql> select * from memory_summary_by_account_by_event_name  order by CURRENT_NUMBER_OF_BYTES_USED desc  limit 2 \G;
*************************** 1. row ***************************
                        USER: root
                        HOST: localhost
                  EVENT_NAME: memory/sql/String::value
                 COUNT_ALLOC: 1657
                  COUNT_FREE: 1613
   SUM_NUMBER_OF_BYTES_ALLOC: 414792
    SUM_NUMBER_OF_BYTES_FREE: 226000
              LOW_COUNT_USED: 0
          CURRENT_COUNT_USED: 44
             HIGH_COUNT_USED: 52
    LOW_NUMBER_OF_BYTES_USED: 0
CURRENT_NUMBER_OF_BYTES_USED: 188792
   HIGH_NUMBER_OF_BYTES_USED: 262656
*************************** 2. row ***************************
                        USER: dao
                        HOST: 192.168.2.1
                  EVENT_NAME: memory/sql/String::value
                 COUNT_ALLOC: 2316
                  COUNT_FREE: 2261
   SUM_NUMBER_OF_BYTES_ALLOC: 774776
    SUM_NUMBER_OF_BYTES_FREE: 589480
              LOW_COUNT_USED: 0
          CURRENT_COUNT_USED: 55
             HIGH_COUNT_USED: 64
    LOW_NUMBER_OF_BYTES_USED: 0
CURRENT_NUMBER_OF_BYTES_USED: 185296
   HIGH_NUMBER_OF_BYTES_USED: 401672
2 rows in set (0.03 sec)

详解 date: 2021-10-19 categories: blog tags: [MySQL] description: memory_summary_by_account_by_event_name 详解 —

系统表介绍

memory_summary_by_account_by_event_name 记录了事件对内存的使用,按照访客与事件进行分组统计.

列名	含义
USER	用户名
HOST	客户端IP
EVENT_NAME	事件名
COUNT_ALLOC	内存分配次数
COUNT_FREE	内存释放次数
SUM_NUMBER_OF_BYTES_ALLOC	总内存分配大小
SUM_NUMBER_OF_BYTES_FREE	总内存释放大小
LOW_COUNT_USED	当前持有的内存块数量
CURRENT_COUNT_USED	持有内存块的低水位线
HIGH_COUNT_USED	持有内存块的高水位线
LOW_NUMBER_OF_BYTES_USED	持有内存字节数的低水位线
CURRENT_NUMBER_OF_BYTES_USED	当前持有内存的数量
HIGH_NUMBER_OF_BYTES_USED	持有内存字节数的高水位线

实例

mysql> select * from memory_summary_by_account_by_event_name  order by CURRENT_NUMBER_OF_BYTES_USED desc  limit 2 \G;
*************************** 1. row ***************************
                        USER: root
                        HOST: localhost
                  EVENT_NAME: memory/sql/String::value
                 COUNT_ALLOC: 1657
                  COUNT_FREE: 1613
   SUM_NUMBER_OF_BYTES_ALLOC: 414792
    SUM_NUMBER_OF_BYTES_FREE: 226000
              LOW_COUNT_USED: 0
          CURRENT_COUNT_USED: 44
             HIGH_COUNT_USED: 52
    LOW_NUMBER_OF_BYTES_USED: 0
CURRENT_NUMBER_OF_BYTES_USED: 188792
   HIGH_NUMBER_OF_BYTES_USED: 262656
*************************** 2. row ***************************
                        USER: dao
                        HOST: 192.168.2.1
                  EVENT_NAME: memory/sql/String::value
                 COUNT_ALLOC: 2316
                  COUNT_FREE: 2261
   SUM_NUMBER_OF_BYTES_ALLOC: 774776
    SUM_NUMBER_OF_BYTES_FREE: 589480
              LOW_COUNT_USED: 0
          CURRENT_COUNT_USED: 55
             HIGH_COUNT_USED: 64
    LOW_NUMBER_OF_BYTES_USED: 0
CURRENT_NUMBER_OF_BYTES_USED: 185296
   HIGH_NUMBER_OF_BYTES_USED: 401672
2 rows in set (0.03 sec)