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 | 1373 | 7151584363968 | 5208728448 | 109667697744 | 1538660112 | 145134900240 | 7004910803616 | 8 | 70656 | 8832.0000 | 829 | 1052160 | 1269.1918 | |
innodb/innodb_data_file | 3791 | 6225183535296 | 1642095312 | 891204997056 | 256056714672 | 45578754144 | 5923548066480 | 1510 | 29851648 | 19769.3033 | 1514 | 57262080 | 37821.7173 | |
innodb/innodb_temp_file | 120 | 577026058224 | 4808550384 | 38329726512 | 0 | 3348650448 | 573677407776 | 0 | 0 | 0.0000 | 50 | 2129920 | 42598.4000 | |
sql/binlog | 746 | 460906467120 | 617836824 | 35297885568 | 1557832848 | 1428398928 | 457920235344 | 170 | 1423 | 8.3706 | 31 | 11879 | 383.1935 | |
sql/ERRMSG | 90 | 55439285616 | 615991992 | 3082475088 | 30318116400 | 0 | 25121169216 | 54 | 5523992 | 102296.1481 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 54526269600 | 1434901776 | 30193115040 | 2654545344 | 0 | 51871724256 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 8310 | 5676785664 | 682968 | 1336526928 | 5471204112 | 0 | 205581552 | 7302 | 492896 | 67.5015 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 1672512864 | 104531856 | 494057520 | 1610763792 | 0 | 61749072 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1189436160 | 237887232 | 1168990416 | 1170636192 | 0 | 18799968 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/io_cache | 60 | 1134987744 | 18916392 | 78850992 | 140534064 | 516521280 | 477932400 | 16 | 1115648 | 69728.0000 | 24 | 1098152 | 45756.3333 | |
sql/casetest | 15 | 999220992 | 66614592 | 941502144 | 0 | 0 | 999220992 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 291347760 | 97115832 | 275546832 | 275546832 | 0 | 15800928 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 8 | 290265360 | 36283104 | 181630944 | 0 | 0 | 290265360 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 18389712 | 6129816 | 11433312 | 0 | 6089952 | 12299760 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|