memory_by_host_by_current_bytes and x$memory_by_host_by_current_bytes Views

MariaDB starting with 10.6

These Sys Schema views were introduced in MariaDB 10.6.

Description

The memory_by_host_by_current_bytes and x$memory_by_host_by_current_bytes summarize memory use grouped by host. Rows by default are sorted by descending amount of memory used.

The memory_by_host_by_current_bytes view is intended to be easier for human reading, while the x$memory_by_host_by_current_bytes view provides the data in raw form, intended for tools that process the data.

They contain the following columns:

ColumnDescription
hostHost from which the client connected. If the HOST column in the underlying Performance Schema table is NULL, rows are assumed to be for background threads, and the background host name is used.
current_count_usedCurrent number of allocated memory blocks that have not yet been freed for the host.
current_allocatedCurrent number of allocated bytes that have not yet been freed for the host.
current_avg_allocCurrent number of allocated bytes per memory block for the host.
current_max_allocLargest single current memory allocation in bytes for the host.
total_allocatedTotal memory allocation in bytes for the host.

Comments

Comments loading...
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.