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 | 656 | 3847410387744 | 5864954832 | 283309614192 | 1819187568 | 51872799264 | 3793718400912 | 8 | 70656 | 8832.0000 | 374 | 315392 | 843.2941 | |
innodb/innodb_data_file | 2832 | 3602037471648 | 1271905800 | 204107782560 | 280696527408 | 35837466192 | 3285503478048 | 1521 | 30031872 | 19744.8205 | 847 | 36028416 | 42536.5006 | |
innodb/innodb_temp_file | 737 | 1377364929600 | 1868880288 | 33646830096 | 0 | 119750842992 | 1257614086608 | 0 | 0 | 0.0000 | 630 | 14057472 | 22313.4476 | |
sql/binlog | 552 | 110271254544 | 199766688 | 24051409536 | 1821773712 | 6463575360 | 101985905472 | 134 | 1279 | 9.5448 | 6 | 1194 | 199.0000 | |
sql/binlog_index | 38 | 79966011312 | 2104368552 | 42666337824 | 297908160 | 0 | 79668103152 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 28988841552 | 483147192 | 2411078736 | 15239810784 | 0 | 13749030768 | 36 | 3686455 | 102401.5278 | 0 | 0 | 0.0000 | |
sql/io_cache | 358 | 19619997408 | 54804288 | 12979834560 | 1110229824 | 3393498240 | 15116269344 | 162 | 8660400 | 53459.2593 | 146 | 8660400 | 59317.8082 | |
sql/casetest | 15 | 1222589808 | 81505776 | 1157854368 | 0 | 0 | 1222589808 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 628430352 | 125685912 | 607543200 | 608971968 | 0 | 19458384 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 283186992 | 70796616 | 249570288 | 264224400 | 0 | 18962592 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 278992032 | 92997168 | 267183312 | 267183312 | 0 | 11808720 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 215864352 | 71954784 | 199829520 | 0 | 0 | 215864352 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 20008032 | 6669168 | 11877888 | 0 | 7323888 | 12684144 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 8373552 | 4186776 | 7953264 | 0 | 0 | 8373552 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|