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 | 1130 | 6453075993936 | 5710686696 | 123628533600 | 1148062608 | 262780792560 | 6189147138768 | 8 | 70656 | 8832.0000 | 669 | 671744 | 1004.1016 | |
innodb/innodb_data_file | 3488 | 4752074113248 | 1362406320 | 208012862112 | 275708028816 | 58311285648 | 4418054798784 | 1570 | 30834688 | 19639.9287 | 1335 | 51593216 | 38646.6037 | |
innodb/innodb_temp_file | 147 | 841852377168 | 5726886792 | 127632673872 | 0 | 2526746112 | 839325631056 | 0 | 0 | 0.0000 | 70 | 2916352 | 41662.1714 | |
sql/binlog | 321 | 245561264256 | 764988312 | 23508215808 | 1150111776 | 2578368144 | 241832784336 | 70 | 876 | 12.5143 | 17 | 4799 | 282.2941 | |
sql/ERRMSG | 70 | 59970853536 | 856726464 | 5665795872 | 31230585408 | 0 | 28740268128 | 42 | 4302072 | 102430.2857 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 51206038752 | 1347527280 | 34578879456 | 474857328 | 0 | 50731181424 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 94 | 4484607600 | 47708496 | 1647132432 | 356057328 | 1847250240 | 2281300032 | 46 | 2280572 | 49577.6522 | 38 | 2280572 | 60015.0526 | |
sql/casetest | 15 | 888087024 | 59205696 | 816213024 | 0 | 0 | 888087024 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 791587104 | 158317368 | 756155136 | 757950864 | 0 | 33636240 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 4 | 757316208 | 189328920 | 719632320 | 0 | 0 | 757316208 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 523917504 | 65489688 | 219400368 | 361181568 | 0 | 162735936 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 489809760 | 122452440 | 473525712 | 475466112 | 0 | 14343648 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 244498848 | 81499440 | 222864576 | 222864576 | 0 | 21634272 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 9 | 141117504 | 15679488 | 29466624 | 0 | 0 | 141117504 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 6 | 20720832 | 3453384 | 9510864 | 0 | 0 | 20720832 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13318800 | 4439424 | 10737408 | 0 | 1844304 | 11474496 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|