How do you display the whole query in mysql "show processlist"?

Question

The Info field of the output gets truncated a lot. How can I force mysql to show the whole query being processed?

$ mysql -uroot -e 'show processlist\G'
*************************** 1. row ***************************
     Id: 2672
   User: root
   Host: localhost
     db: plummelo_development
Command: Query
   Time: 173
  State: Copying to tmp table
   Info: SELECT SQL_NO_CACHE `recipes`.`id` * 2 + 0 AS `id` , `recipes`.`title` AS `title`, GROUP_CONCAT(DIST

possible duplicate of [How to see full query from SHOW PROCESSLIST](http://stackoverflow.com/questions/3638689/how-to-see-full-query-from-show-processlist) — Erik, Sep 09 '15 at 23:14

score 6 · Accepted Answer · answered Apr 27 '11 at 00:40

6

Use SHOW FULL PROCESSLIST:

mysql -uroot -e 'show full processlist\G'

answered Apr 27 '11 at 00:40

Ike Walker

64,401
14
110
109

How do you display the whole query in mysql "show processlist"?

1 Answers1