12 February 2009

Mysql diagnostics

You can see which queries are running and who is connected by running

mysqladmin processlist -i10 -u root -p

you can kill a listed connection by running

mysqladmin kill pid1,pid2 -u root -p