CentOS 7.x mariadb monitoring

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:

• https://stackoverflow.com/questions/568564/how-can-i-view-live-mysql-queries

Home > CentOS > CentOS 7.x > Databases > MariaDB > CentOS 7.x mariadb monitoring