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 | 778 | 4895575764816 | 6292513656 | 480008381952 | 1073523792 | 138820061952 | 4755682179072 | 8 | 70656 | 8832.0000 | 448 | 339968 | 758.8571 | |
innodb/innodb_data_file | 2960 | 3832351212096 | 1294713024 | 253303026240 | 325646188560 | 49025866560 | 3457679156976 | 1550 | 30507008 | 19681.9406 | 892 | 37306368 | 41823.2825 | |
innodb/innodb_temp_file | 161 | 789056733168 | 4900973352 | 40455439728 | 0 | 3956896416 | 785099836752 | 0 | 0 | 0.0000 | 81 | 3293184 | 40656.5926 | |
sql/binlog_index | 38 | 45848057904 | 1206527784 | 22550483472 | 503873040 | 0 | 45344184864 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 38144324064 | 693533016 | 3358478112 | 23466567696 | 0 | 14677756368 | 33 | 3380492 | 102439.1515 | 0 | 0 | 0.0000 | |
sql/binlog | 233 | 37056875328 | 159042312 | 16678869504 | 754100160 | 41899440 | 36260875728 | 55 | 816 | 14.8364 | 3 | 156 | 52.0000 | |
myisam/kfile | 8 | 3031486128 | 378935568 | 2397384528 | 2965423824 | 0 | 66062304 | 4 | 904 | 226.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 2043745440 | 255468048 | 1237815216 | 709365360 | 0 | 1334380080 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 971202144 | 64746792 | 908271408 | 0 | 0 | 971202144 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 30 | 755378448 | 25179264 | 260320368 | 52258272 | 283232400 | 419887776 | 8 | 557824 | 69728.0000 | 12 | 549076 | 45756.3333 | |
mysys/cnf | 5 | 447925632 | 89584968 | 427234368 | 428765568 | 0 | 19160064 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 20 | 386773728 | 19338528 | 263711184 | 32117184 | 0 | 354656544 | 7 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 233086656 | 77695464 | 219988560 | 219988560 | 0 | 13098096 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 6 | 47451360 | 7908384 | 29272320 | 0 | 0 | 47451360 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46983552 | 15661008 | 37026528 | 0 | 7612176 | 39371376 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 13314576 | 13314576 | 13314576 | 0 | 0 | 13314576 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|