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 | 418 | 2184324678010 | 5225656900 | 106629735400 | 934892970 | 43136406380 | 2140253378660 | 8 | 70656 | 8832.0000 | 246 | 265728 | 1080.1951 | |
innodb/innodb_data_file | 2232 | 1918422479680 | 859508155 | 244354912120 | 252413569010 | 18428672400 | 1647580238270 | 1423 | 28426240 | 19976.2755 | 447 | 24166400 | 54063.5347 | |
innodb/innodb_temp_file | 98 | 423934495180 | 4325862120 | 32499752110 | 0 | 2480722240 | 421453772940 | 0 | 0 | 0.0000 | 35 | 1425408 | 40725.9429 | |
sql/binlog | 229 | 136479539980 | 595980495 | 23836475990 | 1278890530 | 9224016120 | 125976633330 | 51 | 800 | 15.6863 | 9 | 1760 | 195.5556 | |
sql/binlog_index | 38 | 55559302690 | 1462086885 | 34599833650 | 1974518180 | 0 | 53584784510 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 35 | 22583389040 | 645239490 | 3398354170 | 10124017600 | 0 | 12459371440 | 21 | 2153932 | 102568.1905 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1535867390 | 307173425 | 1505513760 | 1508354560 | 0 | 27512830 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 764367060 | 50957645 | 695139520 | 0 | 0 | 764367060 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 645158930 | 161289600 | 628056890 | 630082020 | 0 | 15076910 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 261020760 | 87006920 | 248175150 | 248175150 | 0 | 12845610 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 209533380 | 52383345 | 154043440 | 0 | 0 | 209533380 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 62282950 | 20760895 | 37800130 | 0 | 21521180 | 40761770 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 7050590 | 3525295 | 6772340 | 0 | 0 | 7050590 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|