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 | 8977 | 42399066492288 | 4723077216 | 120519114672 | 1355798400 | 1387648478304 | 41010062215584 | 8 | 70656 | 8832.0000 | 5938 | 10252800 | 1726.6420 | |
innodb/innodb_data_file | 8662 | 17701472873568 | 2043577800 | 243385153968 | 340967017776 | 300490109040 | 17060015746752 | 1547 | 30457856 | 19688.3361 | 4853 | 165953536 | 34196.0717 | |
sql/binlog | 958 | 2650741394928 | 2766953376 | 38528658432 | 837730608 | 16553231376 | 2633350432944 | 143 | 1168 | 8.1678 | 192 | 120304 | 626.5833 | |
innodb/innodb_temp_file | 174 | 1266045722304 | 7276124592 | 534676177200 | 0 | 666976172544 | 599069549760 | 0 | 0 | 0.0000 | 99 | 3260416 | 32933.4949 | |
sql/ERRMSG | 70 | 52177933632 | 745398984 | 5013934992 | 32809629600 | 0 | 19368304032 | 42 | 4304471 | 102487.4048 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 51444250176 | 1353795960 | 29137519488 | 519955920 | 0 | 50924294256 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 3162686208 | 395335776 | 1928786640 | 941359056 | 0 | 2221327152 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 14 | 2708222880 | 193444416 | 2195664768 | 2432320176 | 0 | 275902704 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1961072256 | 392214240 | 1944013104 | 1945159920 | 0 | 15912336 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/io_cache | 60 | 1830135648 | 30502032 | 512969952 | 157227840 | 701017152 | 971890656 | 16 | 1115648 | 69728.0000 | 24 | 1098152 | 45756.3333 | |
csv/data | 40 | 759749232 | 18993480 | 467437872 | 523291824 | 0 | 236457408 | 16 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 737784960 | 49185576 | 655141344 | 0 | 0 | 737784960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 25 | 706180464 | 28247208 | 465594096 | 0 | 0 | 706180464 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 314182176 | 104727216 | 298867536 | 298867536 | 0 | 15314640 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 10 | 306918480 | 30691848 | 260975616 | 0 | 0 | 306918480 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12233232 | 4077744 | 9910560 | 0 | 1705968 | 10527264 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|