[MDEV-292] add new log_slow_verbosity values - like in Percona Server Created: 2012-05-24  Updated: 2017-03-29

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Colin Charles Assignee: Unassigned
Resolution: Unresolved Votes: 2
Labels: None


 Description   

Percona has added more values to the log_slow_verbosity variable.

http://www.percona.com/doc/percona-server/5.1/diagnostics/slow_extended.html?id=percona-server:features:slow_extended_51&#log_slow_verbosity

We need to look at these new values and see if we want to implement them.



 Comments   
Comment by Colin Charles [ 2014-05-16 ]

Lot more enhancements in 5.6 - http://www.percona.com/doc/percona-server/5.6/diagnostics/slow_extended.html#slow-extended

Comment by Andreas Schnederle-Wagner [ 2017-03-29 ]

Any chance that you implement the same values as Percona did with "log_slow_verbosity=full"?

# Time: 111229  3:11:26
# User@Host: msandbox[msandbox] @ localhost []
# Thread_id: 1  Schema: test  Last_errno: 0  Killed: 0
# Query_time: 0.117904  Lock_time: 0.002886  Rows_sent: 1  Rows_examined: 655360  Rows_affected: 0  Rows_read: 655361
# Bytes_sent: 68  Tmp_tables: 0  Tmp_disk_tables: 0  Tmp_table_sizes: 0
# InnoDB_trx_id: F00
# QC_Hit: No  Full_scan: Yes  Full_join: No  Tmp_table: No  Tmp_table_on_disk: No
# Filesort: No  Filesort_on_disk: No  Merge_passes: 0
#   InnoDB_IO_r_ops: 984  InnoDB_IO_r_bytes: 16121856  InnoDB_IO_r_wait: 0.001414
#   InnoDB_rec_lock_wait: 0.000000  InnoDB_queue_wait: 0.000000
#   InnoDB_pages_distinct: 973

This would make debugging way more efficent as it's possible right now ...

Thank you
Andreas Schnederle-Wagner

Generated at Thu Feb 08 06:27:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.