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 | 791 | 4611060982704 | 5829406968 | 102058948992 | 1461535152 | 122506305504 | 4487093142048 | 8 | 70656 | 8832.0000 | 454 | 358400 | 789.4273 | |
innodb/innodb_data_file | 2978 | 4075054739712 | 1368386184 | 205371479280 | 262274918400 | 30355515168 | 3782424306144 | 1501 | 29704192 | 19789.6016 | 968 | 39501824 | 40807.6694 | |
innodb/innodb_temp_file | 169 | 759610324704 | 4494735432 | 30950186256 | 0 | 2660488512 | 756949836192 | 0 | 0 | 0.0000 | 82 | 3768320 | 45955.1220 | |
sql/binlog | 2613 | 73453241664 | 28110456 | 15194873232 | 2820509472 | 648359184 | 69984373008 | 649 | 3192 | 4.9183 | 5 | 670 | 134.0000 | |
sql/binlog_index | 38 | 48398080368 | 1273633680 | 31469155872 | 1496561616 | 0 | 46901518752 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 44736202896 | 813385320 | 6362600112 | 20405850960 | 0 | 24330351936 | 33 | 3380902 | 102451.5758 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 4722891888 | 295180512 | 2334009744 | 4611603744 | 0 | 111288144 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1665634608 | 333126816 | 1633058064 | 1634324736 | 0 | 31309872 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 1270270320 | 158783592 | 641365296 | 971063280 | 0 | 299207040 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 722970336 | 48197952 | 659063328 | 0 | 0 | 722970336 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 497520672 | 124380168 | 435527136 | 0 | 0 | 497520672 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 313 | 417446832 | 1333464 | 195073824 | 267688608 | 0 | 149758224 | 200 | 11892 | 59.4600 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 262025808 | 87341760 | 246856896 | 246856896 | 0 | 15168912 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 25067856 | 8355864 | 12729024 | 0 | 0 | 25067856 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 21567744 | 7189248 | 14763408 | 0 | 5852352 | 15715392 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|