Bug #116153 Performance_schema.processlist’s INFO column of execute command is NULL

• Submitted: 19 Sep 1:40
• Modified: 19 Sep 9:18
• Reporter: QIFAN WU
• Status: Unsupported
• Category: MySQL Server: Performance Schema
• Severity: S3 (Non-critical)
• Version: 8.0.24
• OS: Any
• CPU Architecture: Any
• Tags: execute, performance_schema, prepare

[19 Sep 1:40] QIFAN WU

Description:
When I run sysbench to test, I found that the INFO column in performance_schema.processlist was always NULL. After analyzing the code, I learned that in the dispatch_command function, the thread will copy the SQL statement from thd to the local variable of pfs, but this process is only Occurs when the command type is COM_QUERY. Other types such as COM_STMT_EXECUTE do not record sql.

How to repeat:
run sysbench and select * from performance_schema.processlist
Execute through the client cannot be reproduced because the command type of execute is also set to COM_QUERY in the client.

[19 Sep 1:43] QIFAN WU

My sysbench version is 1.0.17

[19 Sep 9:18] MySQL Verification Team

Hi Mr. WU,

Thank you for your bug report.

However, your 8.0 release is too old for testing.

Please, try to perform the same test with 8.0.39.

Also, we can not reproduce your test case.

Sysbench has many tests and you did not specify which ones.

Unsupported.