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 | 854 | 4742104631088 | 5552815488 | 117397966224 | 1563639792 | 257982420432 | 4482558570864 | 8 | 70656 | 8832.0000 | 518 | 620032 | 1196.9730 | |
innodb/innodb_data_file | 2815 | 3237658003536 | 1150144776 | 222961337808 | 539881093488 | 49121375952 | 2648655534096 | 1398 | 28016640 | 20040.5150 | 1008 | 42090496 | 41756.4444 | |
innodb/innodb_temp_file | 476 | 830151722928 | 1744016208 | 36457674528 | 0 | 32771267760 | 797380455168 | 0 | 0 | 0.0000 | 394 | 8552448 | 21706.7208 | |
sql/binlog | 143 | 186654564624 | 1305276456 | 24927301872 | 3628941888 | 1844498304 | 181181124432 | 27 | 704 | 26.0741 | 14 | 3349 | 239.2143 | |
sql/binlog_index | 38 | 58457567520 | 1538357040 | 41022546576 | 1494270624 | 0 | 56963296896 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 34784086656 | 695681712 | 14480776992 | 12268025616 | 0 | 22516061040 | 30 | 3054182 | 101806.0667 | 0 | 0 | 0.0000 | |
sql/io_cache | 339 | 16564879584 | 48863760 | 5491645632 | 1049413728 | 4457923536 | 11057542320 | 146 | 8450076 | 57877.2329 | 143 | 8450076 | 59091.4406 | |
sql/casetest | 15 | 983535168 | 65568888 | 919182000 | 0 | 0 | 983535168 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 681436272 | 136287096 | 655788144 | 657075408 | 0 | 24360864 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 317923056 | 63584400 | 267528096 | 0 | 0 | 317923056 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 277080144 | 92359872 | 237049824 | 237049824 | 0 | 40030320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 14126640 | 4708704 | 9380448 | 0 | 3822192 | 10304448 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|