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 | 574 | 3368406958224 | 5868304728 | 117397966224 | 1563639792 | 222833388096 | 3144009930336 | 8 | 70656 | 8832.0000 | 340 | 397312 | 1168.5647 | |
innodb/innodb_data_file | 2284 | 2318423892048 | 1015071552 | 222961337808 | 519761177760 | 38471560512 | 1760191153776 | 1313 | 26624000 | 20277.2277 | 667 | 31440896 | 47137.7751 | |
innodb/innodb_temp_file | 364 | 711506051520 | 1954686888 | 36457674528 | 0 | 31655823408 | 679850228112 | 0 | 0 | 0.0000 | 290 | 6324224 | 21807.6690 | |
sql/binlog | 97 | 150726866400 | 1553884992 | 24927301872 | 3592866288 | 1437525936 | 145696474176 | 17 | 664 | 39.0588 | 11 | 2586 | 235.0909 | |
sql/binlog_index | 38 | 58457567520 | 1538357040 | 41022546576 | 1494270624 | 0 | 56963296896 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 40 | 17150093136 | 428752104 | 1960301904 | 9361254144 | 0 | 7788838992 | 24 | 2443567 | 101815.2917 | 0 | 0 | 0.0000 | |
sql/io_cache | 105 | 12475209648 | 118811352 | 5491645632 | 353401488 | 2063050704 | 10058757456 | 38 | 2754832 | 72495.5789 | 47 | 2754832 | 58613.4468 | |
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 | |
mysys/charset | 3 | 277080144 | 92359872 | 237049824 | 237049824 | 0 | 40030320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 50394960 | 12598608 | 13207392 | 0 | 0 | 50394960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 14126640 | 4708704 | 9380448 | 0 | 3822192 | 10304448 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|