SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 2099 | 11314203271536 | 5390282568 | 342611491200 | 1308393504 | 395192290944 | 10917702587088 | 8 | 70656 | 8832.0000 | 1320 | 1799680 | 1363.3939 | |
innodb/innodb_data_file | 3577 | 5449659472752 | 1523527896 | 246859888176 | 250473346992 | 79211476608 | 5119974649152 | 1542 | 30375936 | 19699.0506 | 1299 | 51625984 | 39742.8668 | |
sql/binlog | 246 | 726335887200 | 2952584712 | 26330184144 | 2964100128 | 2001908832 | 721369878240 | 35 | 883 | 25.2286 | 51 | 21300 | 417.6471 | |
innodb/innodb_temp_file | 196 | 480387052992 | 2450954352 | 37221783984 | 0 | 6343652832 | 474043400160 | 0 | 0 | 0.0000 | 130 | 3178496 | 24449.9692 | |
sql/binlog_index | 38 | 40841345952 | 1074772248 | 25226289792 | 428287200 | 0 | 40413058752 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 31356179184 | 570112224 | 3804564720 | 16039297296 | 0 | 15316881888 | 33 | 3381415 | 102467.1212 | 0 | 0 | 0.0000 | |
sql/io_cache | 76 | 9636869616 | 126800784 | 7788069168 | 486282192 | 1041056016 | 8109531408 | 34 | 1855800 | 54582.3529 | 32 | 1855800 | 57993.7500 | |
sql/casetest | 15 | 851667696 | 56777688 | 766341312 | 0 | 0 | 851667696 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 596326896 | 119265168 | 560220144 | 576318336 | 0 | 20008560 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 495448272 | 61930968 | 200712336 | 350674368 | 0 | 144773904 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 375203664 | 125067888 | 343525248 | 343525248 | 0 | 31678416 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 265574496 | 66393624 | 247611936 | 249629952 | 0 | 15944544 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 230702208 | 57675552 | 196476192 | 0 | 0 | 230702208 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 65132496 | 10855416 | 16564416 | 0 | 0 | 65132496 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13321968 | 4440480 | 10891584 | 0 | 1792560 | 11529408 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 6953232 | 3476616 | 6687120 | 0 | 0 | 6953232 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|