CentOs 8.x mariadb monitoring

Home > CentOS > CentOS 8.x > CentOS 8.x database servers > CentOS 8.x mariadb > 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.

Home > CentOS > CentOS 8.x > CentOS 8.x database servers > CentOS 8.x mariadb > CentOs 8.x mariadb monitoring