MySQL Bugs: #116153: Performance_schema.processlist’s INFO column of execute command is NULL

Bug #116153	Performance_schema.processlist’s INFO column of execute command is NULL
Submitted:	19 Sep 2024 1:40	Modified:	23 Sep 2024 12:51
Reporter:	QIFAN WU	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Performance Schema	Severity:	S3 (Non-critical)
Version:	8.0.24	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	execute, performance_schema, prepare

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.

My sysbench version is 1.0.17

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.

my sysbench command:
sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-host=127.0.0.1 --mysql-port=4040 --mysql-user=user --mysql-password=password --mysql-db=sbtest1 --table-size=4000000 --tables=1 --threads=1 --time=6000 --report-interval=1 run

actually, we copy sql info from thd to performance thread local info in mysql_parse, but not in mysqld_stmt_execute
thd->set_query_for_display(thd->query().str, thd->query().length)

Hi Mr. WU,

We ran all your commands and  we could not repeat your problem with our latest official 8.0.39 binary:

+----+-----------------+-----------+---------+---------+------+------------------------+---------------------------------------------------------------------+------------------+
| ID | USER            | HOST      | DB      | COMMAND | TIME | STATE                  | INFO                                                                | EXECUTION_ENGINE |
+----+-----------------+-----------+---------+---------+------+------------------------+---------------------------------------------------------------------+------------------+
| 13 | sinisa          | localhost | sbtest1 | Execute |    0 | executing              | SELECT c FROM sbtest1 WHERE id BETWEEN 199938 AND 200037 ORDER BY c | PRIMARY          |
| 15 | sinisa          | localhost | NULL    | Query   |    0 | executing              | select * from performance_schema.processlist                        | PRIMARY          |
+----+-----------------+-----------+---------+---------+------+--------------------\

The same result we get when it is not "Execute" bug "Closed".

Can't repeat.

Hi Mr. WU,

We ran all your commands and  we could not repeat your problem with our latest official 8.0.39 binary:

+----+-----------------+-----------+---------+---------+------+------------------------+---------------------------------------------------------------------+------------------+
| ID | USER            | HOST      | DB      | COMMAND | TIME | STATE                  | INFO                                                                | EXECUTION_ENGINE |
+----+-----------------+-----------+---------+---------+------+------------------------+---------------------------------------------------------------------+------------------+
| 13 | sinisa          | localhost | sbtest1 | Execute |    0 | executing              | SELECT c FROM sbtest1 WHERE id BETWEEN 199938 AND 200037 ORDER BY c | PRIMARY          |
| 15 | sinisa          | localhost | NULL    | Query   |    0 | executing              | select * from performance_schema.processlist                        | PRIMARY          |
+----+-----------------+-----------+---------+---------+------+--------------------\

The same result we get when it is not "Execute" bug "Closed".

Can't repeat.

Hi Mr. WU,

We ran all your commands and  we could not repeat your problem with our latest official 8.0.39 binary:

+----+-----------------+-----------+---------+---------+------+------------------------+---------------------------------------------------------------------+------------------+
| ID | USER            | HOST      | DB      | COMMAND | TIME | STATE                  | INFO                                                                | EXECUTION_ENGINE |
+----+-----------------+-----------+---------+---------+------+------------------------+---------------------------------------------------------------------+------------------+
| 13 | sinisa          | localhost | sbtest1 | Execute |    0 | executing              | SELECT c FROM sbtest1 WHERE id BETWEEN 199938 AND 200037 ORDER BY c | PRIMARY          |
| 15 | sinisa          | localhost | NULL    | Query   |    0 | executing              | select * from performance_schema.processlist                        | PRIMARY          |
+----+-----------------+-----------+---------+---------+------+--------------------\

The same result we get when it is not "Execute" bug "Closed".

Can't repeat.

Hi Mr. WU,

We ran all your commands and  we could not repeat your problem with our latest official 8.0.39 binary:

+----+-----------------+-----------+---------+---------+------+------------------------+---------------------------------------------------------------------+------------------+
| ID | USER            | HOST      | DB      | COMMAND | TIME | STATE                  | INFO                                                                | EXECUTION_ENGINE |
+----+-----------------+-----------+---------+---------+------+------------------------+---------------------------------------------------------------------+------------------+
| 13 | sinisa          | localhost | sbtest1 | Execute |    0 | executing              | SELECT c FROM sbtest1 WHERE id BETWEEN 199938 AND 200037 ORDER BY c | PRIMARY          |
| 15 | sinisa          | localhost | NULL    | Query   |    0 | executing              | select * from performance_schema.processlist                        | PRIMARY          |
+----+-----------------+-----------+---------+---------+------+--------------------\

The same result we get when it is not "Execute" bug "Closed".

Can't repeat.

Hi Mr. WU,

We ran all your commands and  we could not repeat your problem with our latest official 8.0.39 binary:

+----+-----------------+-----------+---------+---------+------+------------------------+---------------------------------------------------------------------+------------------+
| ID | USER            | HOST      | DB      | COMMAND | TIME | STATE                  | INFO                                                                | EXECUTION_ENGINE |
+----+-----------------+-----------+---------+---------+------+------------------------+---------------------------------------------------------------------+------------------+
| 13 | sinisa          | localhost | sbtest1 | Execute |    0 | executing              | SELECT c FROM sbtest1 WHERE id BETWEEN 199938 AND 200037 ORDER BY c | PRIMARY          |
| 15 | sinisa          | localhost | NULL    | Query   |    0 | executing              | select * from performance_schema.processlist                        | PRIMARY          |
+----+-----------------+-----------+---------+---------+------+--------------------\

The same result we get when it is not "Execute" bug "Closed".

Can't repeat.

Hi Mr. WU,

We ran all your commands and  we could not repeat your problem with our latest official 8.0.39 binary:

+----+-----------------+-----------+---------+---------+------+------------------------+---------------------------------------------------------------------+------------------+
| ID | USER            | HOST      | DB      | COMMAND | TIME | STATE                  | INFO                                                                | EXECUTION_ENGINE |
+----+-----------------+-----------+---------+---------+------+------------------------+---------------------------------------------------------------------+------------------+
| 13 | sinisa          | localhost | sbtest1 | Execute |    0 | executing              | SELECT c FROM sbtest1 WHERE id BETWEEN 199938 AND 200037 ORDER BY c | PRIMARY          |
| 15 | sinisa          | localhost | NULL    | Query   |    0 | executing              | select * from performance_schema.processlist                        | PRIMARY          |
+----+-----------------+-----------+---------+---------+------+--------------------\

The same result we get when it is not "Execute" bug "Closed".

Can't repeat.