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
    

    If you don't use FULL, "only the first 100 characters of each statement are shown 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.