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...") |
m |
||
| Line 1: | Line 1: | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 8.x]] > [[CentOS 8.x database servers]] > [[CentOS 8.x mariadb]] > [[CentOs 8.x mariadb monitoring]] | |||
==Show processlist== | ==Show processlist== | ||
| Line 27: | Line 26: | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 8.x]] > [[CentOS 8.x database servers]] > [[CentOS 8.x mariadb]] > [[CentOs 8.x mariadb monitoring]] | |||
Latest revision as of 17:28, 15 May 2022
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:
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.
Home > CentOS > CentOS 8.x > CentOS 8.x database servers > CentOS 8.x mariadb > CentOs 8.x mariadb monitoring
