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 Queries

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.