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 | 341 | 1763565148224 | 5171745216 | 29281055232 | 1039289328 | 39444968640 | 1723080890256 | 8 | 70656 | 8832.0000 | 196 | 237568 | 1212.0816 | |
innodb/innodb_data_file | 2151 | 1594437070512 | 741253656 | 189355468896 | 177373355280 | 32097948432 | 1384965766800 | 1357 | 28426240 | 20947.8556 | 421 | 23281664 | 55300.8646 | |
innodb/innodb_temp_file | 170 | 683267806848 | 4019222328 | 28535898864 | 0 | 3337343328 | 679930463520 | 0 | 0 | 0.0000 | 87 | 3588096 | 41242.4828 | |
sql/binlog | 365 | 91907669040 | 251801616 | 16857269616 | 7180602528 | 1734341664 | 82992724848 | 92 | 71809 | 780.5326 | 7 | 1302 | 186.0000 | |
sql/ERRMSG | 55 | 59196074256 | 1076292096 | 19049263200 | 24442257312 | 0 | 34753816944 | 33 | 3388358 | 102677.5152 | 0 | 0 | 0.0000 | |
sql/io_cache | 190 | 6956035680 | 36610464 | 1454891856 | 459727488 | 2453943888 | 4042364304 | 82 | 4453920 | 54316.0976 | 78 | 4453920 | 57101.5385 | |
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 | |
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/misc | 2 | 167170080 | 83585040 | 162687888 | 0 | 0 | 167170080 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48384864 | 16128288 | 37736688 | 0 | 7765824 | 40619040 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|