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 | 546 | 2843298671664 | 5207506656 | 32772645840 | 1039289328 | 69679251840 | 2772580130496 | 8 | 70656 | 8832.0000 | 325 | 455168 | 1400.5169 | |
innodb/innodb_data_file | 2523 | 2322846584256 | 920668320 | 189355468896 | 182834785584 | 38132622528 | 2101879176144 | 1373 | 28688384 | 20894.6715 | 705 | 32489472 | 46084.3574 | |
innodb/innodb_temp_file | 284 | 809220982416 | 2849369424 | 28535898864 | 0 | 4565227920 | 804655754496 | 0 | 0 | 0.0000 | 192 | 5898240 | 30720.0000 | |
sql/binlog | 487 | 148875467664 | 305699064 | 16857269616 | 7231437840 | 2361988992 | 139282040832 | 120 | 71921 | 599.3417 | 12 | 2936 | 244.6667 | |
sql/ERRMSG | 60 | 62066652912 | 1034444136 | 19049263200 | 26369113584 | 0 | 35697539328 | 36 | 3694825 | 102634.0278 | 0 | 0 | 0.0000 | |
sql/io_cache | 326 | 13712779344 | 42063648 | 2791029648 | 795196512 | 4950268752 | 7967314080 | 142 | 7802608 | 54947.9437 | 134 | 7802608 | 58228.4179 | |
sql/binlog_index | 23 | 1905983376 | 82868808 | 1276998096 | 226020960 | 0 | 1679962416 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 814425216 | 54294768 | 713752512 | 0 | 0 | 814425216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 485487552 | 161829096 | 318317472 | 0 | 0 | 485487552 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 6 | 471800736 | 78633456 | 266141040 | 269329632 | 0 | 202471104 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 271732032 | 67933008 | 194608128 | 194608128 | 0 | 77123904 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 231193248 | 77064240 | 206145456 | 206145456 | 0 | 25047792 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 209423280 | 41884656 | 184578768 | 186120000 | 0 | 23303280 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48384864 | 16128288 | 37736688 | 0 | 7765824 | 40619040 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|