Description:
Table PROCESSLIST in Performance Schema crops query info. Even more, if I set performance_schema_show_processlist ON, output in SHOW FULL PROCESSLIST would be truncates as well.
How to repeat:
1. Prepare very long query:
echo "select sleep(10), '" >> test.sql
for i in `seq 1 1 1024000`; do echo $i>>test.sql; done
echo "';" >>test.sql
2. Run tests:
mysqlmtr < test.sql > /dev/null
3. Check output of
select * from information_schema.processlist\G
select * from performance_schema.processlist\G
show full processlist\G
It will print:
select * from information_schema.processlist\G
...
12768
12769
12770
1
3 row in set, 1 warning (0,01 sec)
select * from performance_schema.processlist\G
...
274
275
276
277
278
EXECUTION_ENGINE: PRIMARY
3 row in set (0,00 sec)
show full processlist\G (performance_schema_show_processlist ON)
...
274
275
276
277
278
3 rows in set (0,00 sec)
show full processlist\G (performance_schema_show_processlist OFF)
...
1023996
1023997
1023998
1023999
1024000
'
3 rows in set, 1 warning (0,02 sec)
