Bug #114545 performance_schema.processlist tuncates query info
Submitted: 3 Apr 17:26 Modified: 4 Apr 9:39
Reporter: Sveta Smirnova (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:8.0.35, 8.0.36 OS:Any
Assigned to: CPU Architecture:Any

[3 Apr 17:26] Sveta Smirnova
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)
[4 Apr 9:39] MySQL Verification Team
Hello Sveta,

Thank you for the report and feedback.

regards,
Umesh