Dear all expertist,
as right now we found that we just execute the select * from <table> can kill the MySQL and we need some command to find out what is executing SQL process and try to kill some.
when I take a look on the "SHOW FULL PROCESSLIST\G" it seems not what we want.
What is the way you are using, please share.
Also I read this: http://stackoverflow.com/questions/568564/how-can-i-view-live-mysql-queries
"Edit: another alternative is the General Query Log, but having it written to a flat file would remove a lot of possibilities for flexibility of displaying, especially in real-time. If you just want a simple, easy-to-implement way to see what's going on though, enabling the GQL and then using running tail -f on the logfile would do the trick."
What is GQL, how to enable it ? what use is it ?
I come from MS SQL background and we can simply use dbcc opentrac + inputbuff to find out what is the related real time query.
Please share how you dual with it and how to kill that process, like the troublesome "select * from xxx" command.