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 | 762 | 5049851039904 | 6627100920 | 702658584144 | 1459148592 | 178782155904 | 4869609735408 | 8 | 70656 | 8832.0000 | 452 | 613376 | 1357.0265 | |
innodb/innodb_data_file | 2743 | 3805261333104 | 1387262448 | 260410094208 | 284004280560 | 36658170912 | 3484598881632 | 1445 | 28786688 | 19921.5834 | 842 | 36290560 | 43100.4276 | |
innodb/innodb_temp_file | 156 | 671927286624 | 4307226000 | 91363610976 | 0 | 95793869952 | 576133416672 | 0 | 0 | 0.0000 | 87 | 2670592 | 30696.4598 | |
sql/binlog | 467 | 223688200560 | 478989720 | 19549278672 | 1293112656 | 1743082176 | 220652005728 | 107 | 1024 | 9.5701 | 16 | 5569 | 348.0625 | |
sql/binlog_index | 38 | 53134159056 | 1398267288 | 30405174096 | 581688624 | 0 | 52552470432 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 42175213872 | 648849432 | 2740245024 | 24770946288 | 0 | 17404267584 | 39 | 3991686 | 102350.9231 | 0 | 0 | 0.0000 | |
sql/io_cache | 262 | 9236249088 | 35252712 | 1956218880 | 738705264 | 3127728912 | 5369814912 | 98 | 5509876 | 56223.2245 | 104 | 5474884 | 52643.1154 | |
sql/casetest | 15 | 756694224 | 50446176 | 691358976 | 0 | 0 | 756694224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 620978688 | 124195632 | 585911040 | 599333856 | 0 | 21644832 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 266793648 | 88931040 | 254642784 | 254642784 | 0 | 12150864 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 225819264 | 56454816 | 174205680 | 0 | 0 | 225819264 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48508416 | 16169472 | 38550336 | 0 | 7343424 | 41164992 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|