list processes running in MySQL

login to mysql as a root:
mysql -uroot -p
end execute:
mysql> show processlist;
will show you list of processes running in MySQL
and using  \G delimiter will present processes in more readable format.
mysql> show processlist \G

Provided by: ForthScale systems, scalable infrastructure experts


Popular posts from this blog

How to set or disable auto-logout on bash shell

Setting up updates with public yum server for Oracle Enterprise Linux

Setting Filezilla Server on Amazon EC2 instance with passive ftp