The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Memory Instrumentaion

Hello,

Is there a way to enable Memory instrumentation in performance_schema.setup_instruments ?

Thanks for your help

Answer

No, there is no way to do it now.

Memory instrumentation is a new feature in MySQL 5.7, at the moment it's only available in the development milestone releases, not suitable for production use. We have not merged this feature into MariaDB yet. We can consider doing it later, when this feature will stabilize.

Currently you can use MariaDB memory instrumentation that is in the information schema. Per-thread memory usage is visible in the MEMORY_USED column of the INFORMATION_SCHEMA.PROCESSLIST table. Global and session local memory usage is visible in the Memory_used status variable (use SHOW GLOBAL STATUS and SHOW SESSION STATUS).

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.