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 | 856 | 5561525108304 | 6497108640 | 149613670272 | 1212512928 | 283698187872 | 5276614407504 | 8 | 70656 | 8832.0000 | 501 | 461312 | 920.7824 | |
innodb/innodb_data_file | 3156 | 4469407320576 | 1416162000 | 230739617856 | 322286570496 | 67359329664 | 4079761420416 | 1587 | 31113216 | 19605.0510 | 1045 | 42287104 | 40466.1282 | |
innodb/innodb_temp_file | 287 | 1878409336320 | 6544980024 | 530301283776 | 0 | 865384005552 | 1013025330768 | 0 | 0 | 0.0000 | 196 | 5898240 | 30093.0612 | |
sql/binlog | 499 | 309595245168 | 620431152 | 25284690288 | 3383222304 | 2197048128 | 304014974736 | 115 | 1350 | 11.7391 | 19 | 4393 | 231.2105 | |
sql/io_cache | 242 | 73292225952 | 302860272 | 66907633584 | 700616928 | 3447842640 | 69143766384 | 98 | 5980620 | 61026.7347 | 104 | 5980620 | 57505.9615 | |
sql/binlog_index | 38 | 51734625888 | 1361437440 | 31701611568 | 720512496 | 0 | 51014113392 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 41074583616 | 684576288 | 6380553168 | 23883111120 | 0 | 17191472496 | 36 | 3695845 | 102662.3611 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 14774164416 | 1846770552 | 12998780784 | 1296028272 | 0 | 13478136144 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 3351359616 | 418919952 | 1778074320 | 3317734992 | 0 | 33624624 | 4 | 849 | 212.2500 | 0 | 0 | 0.0000 | |
csv/data | 11 | 918588528 | 83507952 | 682527120 | 20098320 | 0 | 898490208 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 786105936 | 52406904 | 717962256 | 0 | 0 | 786105936 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 477592368 | 95518368 | 460636704 | 462166320 | 0 | 15426048 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 11 | 397762992 | 36160080 | 175876272 | 0 | 0 | 397762992 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 314934576 | 104978016 | 285574080 | 285574080 | 0 | 29360496 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 4 | 23628000 | 5907000 | 14338368 | 0 | 0 | 23628000 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 14672064 | 4890600 | 11567424 | 0 | 2323200 | 12348864 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|