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 | 1309 | 6085040510736 | 4648617600 | 49802513904 | 1253312544 | 256629142704 | 5827158055488 | 8 | 70656 | 8832.0000 | 837 | 1380352 | 1649.1661 | |
innodb/innodb_data_file | 3190 | 3114351171360 | 976285464 | 158702608416 | 290149500960 | 74814602544 | 2749387067856 | 1538 | 30408704 | 19771.5891 | 1193 | 48676864 | 40802.0654 | |
innodb/innodb_temp_file | 235 | 729828281952 | 3105652176 | 32644462752 | 0 | 4072014672 | 725756267280 | 0 | 0 | 0.0000 | 155 | 4505600 | 29068.3871 | |
sql/binlog | 227 | 338268975264 | 1490171496 | 23527084416 | 3373257888 | 786479760 | 334109237616 | 44 | 7003 | 159.1591 | 25 | 12873 | 514.9200 | |
sql/ERRMSG | 45 | 29742434304 | 660942744 | 2739582912 | 16804323360 | 0 | 12938110944 | 27 | 2749107 | 101818.7778 | 0 | 0 | 0.0000 | |
sql/io_cache | 74 | 2053295376 | 27747192 | 780312720 | 171867696 | 732827040 | 1148600640 | 34 | 1719708 | 50579.6471 | 30 | 1719708 | 57323.6000 | |
sql/binlog_index | 23 | 1395638112 | 60679872 | 371390448 | 529106688 | 0 | 866531424 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 762213408 | 50814192 | 649998624 | 0 | 0 | 762213408 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 555271728 | 111054240 | 537440112 | 538833504 | 0 | 16438224 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 544121952 | 181373808 | 512163696 | 512163696 | 0 | 31958256 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48935040 | 16311504 | 38849712 | 0 | 7516608 | 41418432 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 2 | 8095824 | 4047912 | 4515456 | 0 | 0 | 8095824 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|