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_temp_file | 305 | 511333728576 | 1676504016 | 28952334576 | 0 | 3792558528 | 507541170048 | 0 | 0 | 0.0000 | 233 | 5259264 | 22571.9485 | |
innodb/innodb_data_file | 1766 | 468330452304 | 265192752 | 59703357120 | 186097900032 | 9316505088 | 272916047184 | 1345 | 28426240 | 21134.7509 | 175 | 15548416 | 88848.0914 | |
innodb/innodb_log_file | 71 | 284281513824 | 4003964976 | 22599006672 | 932558880 | 2331140064 | 281017814880 | 8 | 70656 | 8832.0000 | 34 | 60928 | 1792.0000 | |
sql/binlog | 111 | 36967547232 | 333040752 | 22179567696 | 3206949504 | 21672816 | 33738924912 | 26 | 9337 | 359.1154 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 35 | 23070724512 | 659163384 | 3442136016 | 12300030864 | 0 | 10770693648 | 21 | 2147300 | 102252.3810 | 0 | 0 | 0.0000 | |
sql/io_cache | 104 | 18862065552 | 181365888 | 10950693600 | 291979248 | 3343271712 | 15226814592 | 36 | 2651732 | 73659.2222 | 48 | 2651732 | 55244.4167 | |
sql/casetest | 15 | 844752480 | 56316744 | 746966880 | 0 | 0 | 844752480 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 784074192 | 34090056 | 260070096 | 187052976 | 0 | 597021216 | 5 | 288 | 57.6000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 443030016 | 147676584 | 401792688 | 401792688 | 0 | 41237328 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 214828416 | 42965472 | 194608656 | 195445536 | 0 | 19382880 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13544256 | 4514664 | 11204160 | 0 | 1714416 | 11829840 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 | |
sql/misc | 1 | 6040320 | 6040320 | 6040320 | 0 | 0 | 6040320 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|