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 | 1731 | 7973810390304 | 4606476072 | 293778684144 | 1388960496 | 294358749168 | 7678062680640 | 8 | 70656 | 8832.0000 | 1185 | 2290688 | 1933.0700 | |
innodb/innodb_data_file | 3185 | 3305736372048 | 1037907552 | 249265347408 | 284633564688 | 77417701152 | 2943685106208 | 1344 | 27131904 | 20187.4286 | 1264 | 49889280 | 39469.3671 | |
innodb/innodb_temp_file | 147 | 719115872112 | 4891944552 | 36301208592 | 0 | 4237828320 | 714878043792 | 0 | 0 | 0.0000 | 70 | 2916352 | 41662.1714 | |
sql/binlog | 631 | 551816785872 | 874511352 | 29808022992 | 1529250096 | 7042862640 | 543244673136 | 137 | 1144 | 8.3504 | 38 | 7750 | 203.9474 | |
sql/binlog_index | 38 | 53656061712 | 1412001624 | 33165855888 | 2004162336 | 0 | 51651899376 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 80 | 48524916528 | 606561384 | 6449341536 | 32967047520 | 0 | 15557869008 | 48 | 4913605 | 102366.7708 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 2192041104 | 274005072 | 1052649312 | 1555902480 | 0 | 636138624 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 9 | 1598738064 | 177637416 | 730577760 | 732478032 | 0 | 866260032 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1015297536 | 203059296 | 994640592 | 996268944 | 0 | 19028592 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1001330352 | 66755304 | 929691840 | 0 | 0 | 1001330352 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 243014112 | 81004704 | 229866912 | 229866912 | 0 | 13147200 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 109989264 | 27497184 | 44325072 | 0 | 0 | 109989264 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 8 | 105396192 | 13174392 | 33346368 | 0 | 0 | 105396192 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 90179232 | 22544808 | 57997104 | 0 | 0 | 90179232 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 45462384 | 15154128 | 35883408 | 0 | 6876144 | 38586240 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|