mysqlprocesslist

How to see full query from SHOW PROCESSLIST?

When I issue SHOW PROCESSLIST query, only the first 100 characters of the running SQL query are returned in the info column.

Is it possible to change MySQL config or issue a different kind of request to see complete query (the queries I'm looking at are longer than 100 characters)

Solution 
  • SHOW FULL PROCESSLIST

    "Without the FULL keyword, SHOW PROCESSLIST displays only the first 100 characters of each statement in the Info field"

    When using phpMyAdmin, you should also click on the "Full texts" option ("← T →" on top left corner of a results table) to see untruncated results.