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 | 2493 | 10609450038000 | 4255695840 | 76510713840 | 1251466128 | 350281082448 | 10257917489424 | 8 | 70656 | 8832.0000 | 1658 | 2572800 | 1551.7491 | |
innodb/innodb_data_file | 4321 | 4978644912912 | 1152197376 | 177507452496 | 319661606880 | 98687767728 | 4560295538304 | 1492 | 29556736 | 19810.1448 | 2009 | 72990720 | 36331.8666 | |
innodb/innodb_temp_file | 629 | 1297755311424 | 2063203824 | 34930062816 | 0 | 36166457184 | 1261588854240 | 0 | 0 | 0.0000 | 516 | 12582912 | 24385.4884 | |
sql/binlog | 333 | 493194676656 | 1481065080 | 48729560352 | 1683644688 | 4780856256 | 486730175712 | 64 | 852 | 13.3125 | 35 | 6767 | 193.3429 | |
sql/binlog_index | 38 | 54885724080 | 1444361160 | 37811737392 | 247417104 | 0 | 54638306976 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 40723789392 | 814475640 | 9484481424 | 24391641120 | 0 | 16332148272 | 30 | 3071856 | 102395.2000 | 0 | 0 | 0.0000 | |
sql/io_cache | 380 | 25740461472 | 67737912 | 7723138368 | 762026496 | 5228400144 | 19750034832 | 149 | 9428006 | 63275.2081 | 166 | 9423632 | 56768.8675 | |
mysys/cnf | 5 | 2940380256 | 588075840 | 2920684800 | 2922087168 | 0 | 18293088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 24 | 2797725744 | 116571840 | 718390992 | 2222459184 | 0 | 575266560 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 866976000 | 57798312 | 790178400 | 0 | 0 | 866976000 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 495798864 | 123949584 | 440354640 | 440354640 | 0 | 55444224 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 98 | 379383312 | 3871032 | 238591056 | 249909264 | 0 | 129474048 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 271076256 | 90358752 | 256241040 | 256241040 | 0 | 14835216 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 2 | 268563504 | 134281752 | 262550112 | 0 | 0 | 268563504 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 15278736 | 7639368 | 11039952 | 0 | 0 | 15278736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13808256 | 4602576 | 10735296 | 0 | 2341680 | 11466576 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|