A time will come where one shall need to display the whole details of what is currently running or locking a table in a database being used in development. Unfortunately, we happen to stumble upon such on a production server and the need to have it checked incrementally rises as it is being consistently reported by the client. Thankfully, search engines are now here to aid us young developers who had a dream to be better at one point in time. So without further ado, let us just elaborate this on a short note post.
Normally, one would use a SHOW PROCESSLIST statement to check what’s currently running. However the Info column on this statement would produce a trimmed output. So in the event that one would need to obtain the whole information, please add this to display the whole output of the Info column.
SHOW FULL PROCESSLISTIt is clear that this is a minor concern but as for some who didn’t read the documentation properly, we believe that this is something that would aid those who are in need.
For the full documentation, don’t hesitate to check the info about this at the MySQL website.
Discussion about this post