Show MySQL Running Queries
I know there is an option in SPanel to view currently running mysql queries. But it is limited to show only the first 100 chars from the query, which in most cases is not enough to investigate slow or hanging queries.
- Please add an option to expand the rows and to display the full query
- Please add an option to kill the queries/processes. This will be really useful if we have bad queries.
Additional info: Unfortunately, I'm not aware of any other method to display running queries easily. Remote connection to the DB with HeidiSQL, MySQL Workbench or simply phpMyAdmin does not show any queries with "SHOW PROCESSLIST" (or similar). It's probably some privileges issue, I don't know. So the only option is through SPanel.