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 | 1189 | 6601228464336 | 5551916040 | 50742345984 | 1300219536 | 177904015344 | 6422024229456 | 8 | 70656 | 8832.0000 | 705 | 705024 | 1000.0340 | |
innodb/innodb_data_file | 3439 | 4602825133104 | 1338419544 | 216499813728 | 238865104896 | 64950708768 | 4299009319440 | 1468 | 29163520 | 19866.1580 | 1456 | 55754752 | 38293.0989 | |
innodb/innodb_temp_file | 255 | 664546058880 | 2606062800 | 73640725488 | 0 | 89092395744 | 575453663136 | 0 | 0 | 0.0000 | 182 | 4489216 | 24666.0220 | |
sql/binlog | 335 | 310302778896 | 926276736 | 28360815648 | 2903597664 | 1589728272 | 305809452960 | 71 | 880 | 12.3944 | 22 | 6323 | 287.4091 | |
sql/binlog_index | 38 | 53304932208 | 1402761360 | 26011206144 | 1466168880 | 0 | 51838763328 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 42338544336 | 651362184 | 4074636720 | 20403886272 | 0 | 21934658064 | 39 | 3992068 | 102360.7179 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 2429172240 | 151823232 | 760722336 | 2348170176 | 0 | 81002064 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
sql/io_cache | 98 | 2236066800 | 22816992 | 301288944 | 203711904 | 1639605264 | 392749632 | 52 | 2226960 | 42826.1538 | 36 | 2226960 | 61860.0000 | |
sql/casetest | 15 | 778753008 | 51916656 | 711011664 | 0 | 0 | 778753008 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 678259824 | 84782280 | 331370160 | 551470128 | 0 | 126789696 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 491764944 | 98352936 | 472421136 | 473838816 | 0 | 17926128 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/dfile | 37 | 448699152 | 12126840 | 364319472 | 387887808 | 0 | 60811344 | 26 | 6786 | 261.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 332935152 | 110978208 | 316179600 | 316179600 | 0 | 16755552 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 236966928 | 59241600 | 202751472 | 0 | 0 | 236966928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 65248128 | 10874688 | 13643520 | 0 | 0 | 65248128 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13805616 | 4601784 | 9489744 | 0 | 3655872 | 10149744 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|