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 | 1626 | 7988598819168 | 4913037360 | 47629032000 | 444448224 | 345800534112 | 7642353836832 | 8 | 70656 | 8832.0000 | 991 | 913408 | 921.7033 | |
innodb/innodb_data_file | 3935 | 3203831920080 | 814188408 | 80875522992 | 188144454432 | 91285954320 | 2924401511328 | 1479 | 29835264 | 20172.5923 | 1971 | 72728576 | 36899.3283 | |
innodb/innodb_temp_file | 498 | 887070242256 | 1781265288 | 80439195408 | 0 | 14708856096 | 872361386160 | 0 | 0 | 0.0000 | 406 | 9404416 | 23163.5862 | |
sql/binlog | 603 | 335806648320 | 556893216 | 29926170384 | 12612636960 | 2760586752 | 320433424608 | 138 | 9563 | 69.2971 | 30 | 100668 | 3355.6000 | |
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 | 2 | 16079712 | 8039856 | 13465584 | 0 | 0 | 16079712 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|