zeldor.biz

Linux, programming and more

Copyright © 2021
Log in

MySQL: Show processlist every second

November 28, 2010 by Igor Drobot 4 Comments

MySQL-Logo

1
mysqladmin -u root -p -i 1 processlist

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:

1
2
3
4
5
6
7
8
9
+--------+------+-------------------+-----+---------+------+-------+------------------+
| 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 |
+--------+------+-------------------+-----+---------+------+-------+------------------+

+--------+------+-------------------+-----+---------+------+-------+------------------+ | 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 | +--------+------+-------------------+-----+---------+------+-------+------------------+

Filed Under: MySQL Tagged With: Database, MySQL, Process List

Categories

Archives

Tags

apache2 Apple arduino ARM Automation backup bash Cisco Cluster Corosync Database Debian Debian squeeze DIY Fedora FTP Fun GIT Icinga Ipv6 KVM Linux LVM MAC OS X Monitoring MySQL Nagios Nginx openSUSE OpenVPN PHP Proxy Python python3 qemu RAID Roundcube rsync security ssh Ubuntu virtualization Windows Windows 7 Wordpress

Comments

  1. Guest says

    October 26, 2018 at 10:30

    thank you

  2. jay says

    February 16, 2018 at 10:59

    Thanks , It works perfectly .

  3. Danny Feliz says

    April 8, 2016 at 18:11

    You don’t know how much a I’ve been needing this, for real, thank you man :D

  4. Jeremy Glover says

    February 20, 2016 at 16:40

    This worked out perfectly for me. Thanks for the tip! It made monitoring the queries on MySQL much easier and faster.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *