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 | 1437 | 8212225010880 | 5714839944 | 50742345984 | 1300219536 | 240438098208 | 7970486693136 | 8 | 70656 | 8832.0000 | 847 | 805376 | 950.8571 | |
innodb/innodb_data_file | 3707 | 5811075441600 | 1567595040 | 216499813728 | 238865104896 | 72766091904 | 5499444244800 | 1468 | 29163520 | 19866.1580 | 1619 | 60276736 | 37230.8437 | |
innodb/innodb_temp_file | 285 | 825849382512 | 2897717064 | 73640725488 | 0 | 90197254752 | 735652127760 | 0 | 0 | 0.0000 | 202 | 5472256 | 27090.3762 | |
sql/binlog | 455 | 594787009872 | 1307223984 | 30989449392 | 4742922096 | 2816162448 | 587227925328 | 92 | 964 | 10.4783 | 40 | 11768 | 294.2000 | |
sql/binlog_index | 38 | 53304932208 | 1402761360 | 26011206144 | 1466168880 | 0 | 51838763328 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 70 | 46239950592 | 660570504 | 4074636720 | 22407450384 | 0 | 23832500208 | 42 | 4296334 | 102293.6667 | 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 | 9 | 104239872 | 11582208 | 19009056 | 0 | 0 | 104239872 | 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 |
|