Display Full SQL Query in Show Processlist of MySQL
In MySQL database system, by default the SHOW PROCESSLIST query displays only first 100 characters of the running SQL query or SQL statement in the Info column. The limited and trimmed length of SQL statement may prevent some important information about the SQL statement from been accessed and studied, especially when the SQL statement that is significantly longer than 100 characters.
Here’s the SQL statement to use in you want to display the full SQL statement or query that is been processed by MySQL, so that it will return the complete SQL query including those exceeding 100 characters without truncating:
SHOW FULL PROCESSLIST
If you’re using phpMyAdmin, click on the “Show Full Queries” option (the ← T → symbol on top left corner or next to SQL query heading of a MySQL Server Processes results page) to view the full and complete SQL query without truncation.
LK is a technology writer for Tech Journey with background of system and network administrator. He has be documenting his experiences in digital and technology world for over 15 years.Connect with LK through Tech Journey on Facebook, Twitter or Google+.
