This table summarizes memory usage events aggregated by thread and event name, allowing for detailed memory profiling of individual threads.
There are five memory summary tables in the Performance Schema that share a number of fields in common. These include:
memory_summary_by_thread_by_event_name
The memory_summary_by_thread_by_event_name table contains memory usage statistics aggregated by thread 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.
THREAD_ID
bigint(20) unsigned
NO
NULL
Thread id.
EVENT_NAME
varchar(128)
NO
NULL
Event name.
COUNT_ALLOC