Difference between revisions of "CentOs 8.x mariadb monitoring"
From Notes_Wiki
(Created page with "<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...") |
(No difference)
|
Revision as of 13:50, 8 February 2021
<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:
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:
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>
