[MDEV-384] Update extended statistics in the slow query log Created: 2012-07-06  Updated: 2015-10-29

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

Type: Task Priority: Minor
Reporter: Sergei Petrunia Assignee: Unassigned
Resolution: Unresolved Votes: 2
Labels: None


 Description   

Percona Server 5.5 provides more statistics in the slow query log than 5.1: there are statistics for

  • Tmp_table_sizes
  • InnoDB reads
  • Profiling.

We should port their new patch.

Example of 5.5's statistics:

 
# Time: 120706 13:45:56
# User@Host: root[root] @ localhost []
# Thread_id: 1  Schema: test  Last_errno: 0  Killed: 0
# Query_time: 0.154889  Lock_time: 0.000182  Rows_sent: 999  Rows_examined: 2998  Rows_affected: 0  Rows_read: 999
# Bytes_sent: 8049  Tmp_tables: 1  Tmp_disk_tables: 0  Tmp_table_sizes: 126992
# Profile_starting: 0.000060 Profile_starting_cpu: 0.000123 .... <lots of Profile_xxx omitted >
 
 
# Profile_total: 0.154894 Profile_total_cpu: 0.320510 
# InnoDB_trx_id: 222510A
# QC_Hit: No  Full_scan: Yes  Full_join: Yes  Tmp_table: Yes  Tmp_table_on_disk: No
# Filesort: Yes  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: 23
SET timestamp=1341567956;
select max(B.a) from one_ki A , one_ki B  where A.a < B.a group by A.a;


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