How to get the full query from MySQL process list

MySQL process list can be viewed by the following query.

>SHOW PROCESSLIST;

But this will give the only the first 100 characters of each statement instead of full query.

If we need to get the full query, use the following,

>SHOW FULL PROCESSLIST;

That's all…

Leave a Reply