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 | 9019 | 42609684917712 | 4724435496 | 120519114672 | 1355798400 | 1391948604816 | 41216380514496 | 8 | 70656 | 8832.0000 | 5962 | 10276864 | 1723.7276 | |
innodb/innodb_data_file | 9360 | 18727013101632 | 2000749080 | 243385153968 | 359857492896 | 311809679280 | 18055345929456 | 1572 | 30867456 | 19635.7863 | 5442 | 184729600 | 33945.1672 | |
sql/binlog | 978 | 2650840708560 | 2710470840 | 38528658432 | 852006144 | 16553231376 | 2633435471040 | 148 | 1188 | 8.0270 | 192 | 120304 | 626.5833 | |
innodb/innodb_temp_file | 273 | 1352877286464 | 4955594424 | 534676177200 | 0 | 667963798128 | 684913488336 | 0 | 0 | 0.0000 | 194 | 5079040 | 26180.6186 | |
sql/io_cache | 136 | 174838673328 | 1285578360 | 117607552128 | 432889776 | 2927439504 | 171478344048 | 52 | 2934332 | 56429.4615 | 54 | 2916836 | 54015.4815 | |
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 | |
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 |
|