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 | 2094 | 9697199655792 | 4630945176 | 269302039248 | 1315245360 | 401498358096 | 9294386052336 | 8 | 70656 | 8832.0000 | 1423 | 2458112 | 1727.4153 | |
innodb/innodb_data_file | 3441 | 4088099051520 | 1188055440 | 203763962688 | 215673593520 | 94109161344 | 3778316296656 | 1500 | 29687808 | 19791.8720 | 1287 | 50085888 | 38916.7739 | |
sql/binlog | 359 | 661495306560 | 1842605160 | 21325810176 | 740591280 | 1844928096 | 658909787184 | 63 | 848 | 13.4603 | 50 | 10421 | 208.4200 | |
innodb/innodb_temp_file | 108 | 482900952864 | 4471304904 | 39593707824 | 0 | 1600551216 | 481300401648 | 0 | 0 | 0.0000 | 42 | 1736704 | 41350.0952 | |
sql/binlog_index | 38 | 48715178688 | 1281978192 | 32662372512 | 248518512 | 0 | 48466660176 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 34844979840 | 633545088 | 4464514032 | 19856464320 | 0 | 14988515520 | 33 | 3380458 | 102438.1212 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 6078879840 | 759859848 | 5639217408 | 364168464 | 0 | 5714711376 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 9 | 2019940560 | 224437752 | 1379262192 | 1387693296 | 0 | 632247264 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 874789872 | 58319184 | 796867104 | 0 | 0 | 874789872 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 403074144 | 80614776 | 382821120 | 384627936 | 0 | 18446208 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/dfile | 7 | 355534080 | 50790432 | 253956384 | 0 | 0 | 355534080 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 13 | 294787152 | 22675752 | 199275648 | 18961536 | 0 | 275825616 | 4 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 266962608 | 88987536 | 244262304 | 244262304 | 0 | 22700304 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 9 | 118161120 | 13128984 | 30834144 | 0 | 0 | 118161120 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12555312 | 4184928 | 10125456 | 0 | 1802592 | 10752720 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|