Bug #99261 when log_slow_extra is on,add some new status

• Submitted: 15 Apr 2020 4:56
• Modified: 16 Apr 2020 7:11
• Reporter: Ye Jinrong
• Status: Verified
• Category: MySQL Server: Logging
• Severity: S4 (Feature request)
• Version: 8.0
• OS: Any
• CPU Architecture: Any

[15 Apr 2020 4:56] Ye Jinrong

Description:
when setting
log_slow_extra = on

i wish to add a new status, it can indicate how many pages was read, and how many time innodb wait for io read, just like percona server work:

cat path/slow.log

# Query_time: 0.804438  Lock_time: 0.000083  Rows_sent: 0  Rows_examined: 230730  Rows_affected: 0
# Bytes_sent: 2155  Tmp_tables: 0  Tmp_disk_tables: 0  Tmp_table_sizes: 0
# QC_Hit: No  Full_scan: No  Full_join: No  Tmp_table: No  Tmp_table_on_disk: No
# Filesort: No  Filesort_on_disk: No  Merge_passes: 0
#   InnoDB_IO_r_ops: 0  InnoDB_IO_r_bytes: 0  InnoDB_IO_r_wait: 0.000000
#   InnoDB_rec_lock_wait: 0.000000  InnoDB_queue_wait: 0.000000
#   InnoDB_pages_distinct: 41402

i think status **InnoDB_pages_distinct**, **InnoDB_IO_r_wait**, **InnoDB_rec_lock_wait**, and **InnoDB_queue_wait** are very helpful

How to repeat:
desc above

Suggested fix:
desc above

[16 Apr 2020 7:11] MySQL Verification Team

Hello Ye Jinrong,

Thank you for the feature request!

regards,
Umesh