Skip to main content

If you need to see running processes in MySQL run the following command after you login into MySQL command line:

- Advertisement -

mysql> show processlist;

or, from the command line:

# mysqladmin processlist

The command will list processes with their Id, User, Host, db, Command, time, State and Info details.

So, if you want, for example, to kill process with id 783 from the list, use:

mysql> kill 783

or, from the command line:

mysqladmin kill 783

If you need other information about process you can use the following:

mysql> show table status like '%';

mysql> show status;

mysql> show status\G

mysql> show innodb status;

- Advertisement -