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:

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:

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.