This table summarizes memory usage events aggregated by client host and event name, helping to analyze memory consumption patterns per host.
There are five memory summary tables in the Performance Schema that share a number of fields in common. These include:
memory_summary_by_host_by_event_name
The memory_summary_by_host_by_event_name table contains memory usage statistics aggregated by host and event.
The table contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
bigint(20) unsigned
NO
NULL
Total number of allocations to memory.
COUNT_FREE
bigint(20) unsigned
NO
NULL
Total number of attempts to free the allocated memory.
SUM_NUMBER_OF_BYTES_ALLOC
bigint(20) unsigned
NO
NULL
Total number of bytes allocated.
SUM_NUMBER_OF_BYTES_FREE
bigint(20) unsigned
NO
NULL
Total number of bytes freed
LOW_COUNT_USED
bigint(20)
NO
NULL
Lowest number of allocated blocks (lowest value of CURRENT_COUNT_USED).
CURRENT_COUNT_USED
bigint(20)
NO
NULL
Currently allocated blocks that have not been freed (COUNT_ALLOC minus COUNT_FREE).
HIGH_COUNT_USED
bigint(20)
NO
NULL
Highest number of allocated blocks (highest value of CURRENT_COUNT_USED).
LOW_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Lowest number of bytes used.
CURRENT_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Current number of bytes used (total allocated minus total freed).
HIGH_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Highest number of bytes used.
HOST
char(60)
YES
NULL
Host portion of the account.
EVENT_NAME
varchar(128)
NO
NULL
Event name.
COUNT_ALLOC