shatteredsilicon / ssm-submodules

GNU Affero General Public License v3.0
1 stars 2 forks source link

Track Total Session Memory Usage #230

Closed gordan-bobic closed 7 months ago

gordan-bobic commented 7 months ago

Add this metric to be polled and captured by mysqld_exporter:

SELECT SUM(memory_used) FROM information_schema.processlist;

This metric should be shown on the MySQL -> MySQL Overview -> MySQL Internal Memory Overview graph.

oblitorum commented 7 months ago

It seems the memory_used column only exists in MariaDB, not in MySQL 5.7/8.0. Anyway, I added that metric and it looks like this :

image

gordan-bobic commented 7 months ago

Looks good.