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 | 1651 | 8138651452800 | 4929528384 | 47629032000 | 444448224 | 349673132688 | 7788533871888 | 8 | 70656 | 8832.0000 | 1005 | 920576 | 915.9960 | |
innodb/innodb_data_file | 3962 | 3286411779024 | 829482984 | 80875522992 | 188144454432 | 91573576512 | 3006693748080 | 1479 | 29835264 | 20172.5923 | 1987 | 73154560 | 36816.5878 | |
innodb/innodb_temp_file | 600 | 959182818000 | 1598638008 | 80439195408 | 0 | 15480646896 | 943702171104 | 0 | 0 | 0.0000 | 504 | 11272192 | 22365.4603 | |
sql/binlog | 713 | 348948162816 | 489408216 | 29926170384 | 13168737648 | 3470778432 | 332308646736 | 165 | 9671 | 58.6121 | 31 | 100918 | 3255.4194 | |
sql/io_cache | 102 | 58569487152 | 574210560 | 44968624800 | 263048544 | 46192715184 | 12113723424 | 50 | 2149976 | 42999.5200 | 38 | 2149976 | 56578.3158 | |
sql/ERRMSG | 55 | 36519966912 | 663999336 | 9592521840 | 27311976384 | 0 | 9207990528 | 33 | 3387419 | 102649.0606 | 0 | 0 | 0.0000 | |
myisam/kfile | 87 | 18062992992 | 207620424 | 17570721696 | 58874640 | 173753184 | 17830365168 | 10 | 1904 | 190.4000 | 52 | 2499 | 48.0577 | |
sql/SDI | 15 | 8703696672 | 580246392 | 4774101552 | 0 | 4840190256 | 3863506416 | 0 | 0 | 0.0000 | 5 | 20198 | 4039.6000 | |
myisam/dfile | 4033 | 6615374304 | 1640232 | 1335414960 | 0 | 4896342528 | 1719031776 | 0 | 0 | 0.0000 | 4003 | 103596 | 25.8796 | |
sql/binlog_index | 23 | 914975952 | 39781368 | 216948864 | 579406080 | 0 | 335569872 | 5 | 224 | 44.8000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 771654576 | 51443568 | 692585520 | 0 | 0 | 771654576 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 375032592 | 75006360 | 205213008 | 166132560 | 0 | 208900032 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 329157312 | 109718928 | 316500096 | 316500096 | 0 | 12657216 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 235618944 | 78539472 | 229899648 | 0 | 4313760 | 231305184 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 | |
sql/misc | 3 | 29353104 | 9784368 | 13465584 | 0 | 0 | 29353104 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|