Bug #116653 It is recommended that log_slow_extra also be used for TABLE format
Submitted: 14 Nov 2024 11:57 Modified: 14 Nov 2024 13:28
Reporter: karry zhang (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[14 Nov 2024 11:57] karry zhang
Description:
We see enabling the log_slow_extra system variable causes the server to add extra fields to FILE output.

We recommend adding these fields to the table format as well.

How to repeat:
See the document. https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html

Suggested fix:
We recommend adding these fields to the table format as well.
[14 Nov 2024 12:02] MySQL Verification Team
Hi Mr. zhang,

Thank you for your bug report.

Don't you think that this is not a bug, but feature request ????

I hope you agree that we change severity to "Feature request", after we analyse the output ........
[14 Nov 2024 13:28] MySQL Verification Team
HI Mr. zhang,

This is now a verified feature request for the slow query log.

It applies to version 8.0 and higher.
[14 Nov 2024 15:52] MySQL Verification Team
We would also like to add that `rows_changed` could be also added to the table.