mysql show long running queries

How to kill certain connections to a MySQL database

Maintenance of databases or servers is quite often performed by database administrators at night. But these routines sometimes get blocked by long-running queries or applications that hang onto locks much longer than expected.

(more…)