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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.