Tutorial - MySQL: Show processlist every second | Vevioz Developers

Tutorial MySQL: Show processlist every second

DevOps

Linux Systems Engineer
Joined
Oct 18, 2019
Messages
211
Reaction score
20
Points
18
Location
Novosibirsk, Russia
Website
addons.vevioz.com
Offline
mysqladmin -u root -p -i 1 processlist
-u username
-p you will be promted for a password
-i 1 interval one second

Output will see like this one:
+--------+------+-------------------+-----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------+-------------------+-----+---------+------+-------+------------------+
| 424111 | db4 | 192.168.2.1:58431 | db4 | Sleep | 15 | | |
| 424195 | db4 | 192.168.2.1:50531 | db4 | Sleep | 1 | | |
| 424483 | db3 | 192.168.2.1:41503 | db3 | Sleep | 464 | | |
| 424490 | db3 | 192.168.2.1:41513 | db3 | Sleep | 443 | | |
| 424551 | root | localhost | | Query | 0 | | show processlist |
+--------+------+-------------------+-----+---------+------+-------+------------------+
 
Top Bottom