Performance Schema memory_summary_by_account_by_event_name Table

MariaDB starting with 10.5.2

The memory_summary_by_account_by_event_name table was introduced in MariaDB 10.5.2.

There are five memory summary tables in the Performance Schema that share a number of fields in common. These include:

The memory_summary_by_account_by_event_name table contains memory usage statistics aggregated by account and event.

The table contains the following columns:

FieldTypeNullDefaultDescription
USERchar(32)YESNULLUser portion of the account.
HOSTchar(60)YESNULLHost portion of the account.
EVENT_NAMEvarchar(128)NONULLEvent name.
COUNT_ALLOCbigint(20) unsignedNONULLTotal number of allocations to memory.
COUNT_FREEbigint(20) unsignedNONULLTotal number of attempts to free the allocated memory.
SUM_NUMBER_OF_BYTES_ALLOCbigint(20) unsignedNONULLTotal number of bytes allocated.
SUM_NUMBER_OF_BYTES_FREEbigint(20) unsignedNONULLTotal number of bytes freed
LOW_COUNT_USEDbigint(20)NONULLLowest number of allocated blocks (lowest value of CURRENT_COUNT_USED).
CURRENT_COUNT_USEDbigint(20)NONULLCurrently allocated blocks that have not been freed (COUNT_ALLOC minus COUNT_FREE).
HIGH_COUNT_USEDbigint(20)NONULLHighest number of allocated blocks (highest value of CURRENT_COUNT_USED).
LOW_NUMBER_OF_BYTES_USEDbigint(20)NONULLLowest number of bytes used.
CURRENT_NUMBER_OF_BYTES_USEDbigint(20)NONULLCurrent number of bytes used (total allocated minus total freed).
HIGH_NUMBER_OF_BYTES_USEDbigint(20)NONULLHighest number of bytes used.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.