Difference between revisions of "CentOS 7.x mariadb monitoring"
From Notes_Wiki
(Created page with "<yambe:breadcrumb self="mariadb monitoring">CentOS_7.x_mariadb|CentOS 7.x mariadb</yambe:breadcrumb> =CentOS 7.x mariadb monitoring= ==Monitor queries running on mysql server...") |
m |
||
| Line 1: | Line 1: | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 7.x]] > [[CentOS 7.x databases|Databases]] > [[CentOS 7.x mariadb|MariaDB]] > [[CentOS 7.x mariadb monitoring]] | |||
==Monitor queries running on mysql server== | ==Monitor queries running on mysql server== | ||
| Line 18: | Line 17: | ||
Refer: | Refer: | ||
* https://stackoverflow.com/questions/568564/how-can-i-view-live-mysql-queries | * https://stackoverflow.com/questions/568564/how-can-i-view-live-mysql-queries | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 7.x]] > [[CentOS 7.x databases|Databases]] > [[CentOS 7.x mariadb|MariaDB]] > [[CentOS 7.x mariadb monitoring]] | |||
Latest revision as of 16:04, 28 August 2022
Home > CentOS > CentOS 7.x > Databases > MariaDB > CentOS 7.x mariadb monitoring
Monitor queries running on mysql server
During package (eg owncloud, mediawiki, etc.) upgrades to newer versions queries run at backend for long time (sometimes >60 minutes). If during this time we want to check which queries are actually running then connect to mariadb-command line and use query:
show full processlist;
to see list of currently executing queries and time since which they are executing.
To run it the way watch runs and displays output every few seconds use:
mysqladmin -u <mysql-username> -p -i 1 processlist
Refer:
Home > CentOS > CentOS 7.x > Databases > MariaDB > CentOS 7.x mariadb monitoring
