CentOs 8.x mariadb monitoring

<yambe:breadcrumb self="mariadb monitoring">CentOS 8.x mariadb|mariadb</yambe:breadcrumb>

CentOs 8.x mariadb monitoring

Show processlist

We can list of running queries which can help in checking current usage of the server using:

show processlist;

Refer:

• https://www.mysqltutorial.org/mysql-show-processlist/

Show open tables

We can see which tables are in use if we want to look at DB from table usage point of view:

show open tables where in_use > 0;

Refer:

• https://central.owncloud.org/t/update-oc-filecache-error/18301/6

Query logging

Also consider logging either all queries or at least slow queries as described at MySQL Query logging to get more insight into MySQL DB performance.

<yambe:breadcrumb self="mariadb monitoring">CentOS 8.x mariadb|mariadb</yambe:breadcrumb>