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_data_file | 1642 | 821658811776 | 500401176 | 161998708080 | 167399217744 | 43739714832 | 610519879200 | 1231 | 25280512 | 20536.5654 | 222 | 17121280 | 77122.8829 | |
innodb/innodb_log_file | 134 | 696281227488 | 5196128520 | 42193482144 | 1486456752 | 12042780288 | 682751990448 | 8 | 70656 | 8832.0000 | 72 | 80384 | 1116.4444 | |
innodb/innodb_temp_file | 90 | 321898936128 | 3576654840 | 20079797760 | 0 | 1202671536 | 320696264592 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog_index | 38 | 49167739104 | 1293887760 | 32198466960 | 1156445136 | 0 | 48011293968 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 41 | 30984261264 | 755713464 | 15174795504 | 2364381360 | 27883680 | 28591996224 | 7 | 624 | 89.1429 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 25 | 19593719904 | 783748680 | 3016130304 | 11783286240 | 0 | 7810433664 | 15 | 1530018 | 102001.2000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 848973840 | 56598168 | 783617472 | 0 | 0 | 848973840 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 490262256 | 98052240 | 446739216 | 449310576 | 0 | 40951680 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 210644544 | 70214760 | 199207536 | 199207536 | 0 | 11437008 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 17853264 | 5951088 | 14466144 | 0 | 2499024 | 15354240 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 14172576 | 14172576 | 14172576 | 0 | 0 | 14172576 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|