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 | 1862 | 1247030528304 | 669726288 | 253515515088 | 325719442224 | 16803422592 | 904507663488 | 1380 | 27721728 | 20088.2087 | 249 | 17842176 | 71655.3253 | |
innodb/innodb_log_file | 183 | 1218189467616 | 6656772936 | 79126440624 | 1798597680 | 70198496016 | 1146192373920 | 8 | 70656 | 8832.0000 | 100 | 102400 | 1024.0000 | |
innodb/innodb_temp_file | 96 | 414767234640 | 4320492000 | 43482092544 | 0 | 2515511328 | 412251723312 | 0 | 0 | 0.0000 | 34 | 1343488 | 39514.3529 | |
sql/binlog | 229 | 69220595664 | 302273136 | 19158473136 | 934373616 | 1005674208 | 67280547840 | 53 | 808 | 15.2453 | 5 | 605 | 121.0000 | |
sql/binlog_index | 38 | 52907517696 | 1392303000 | 29335958256 | 1703288928 | 0 | 51204228768 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 28343450784 | 515335392 | 2431280016 | 17153979216 | 0 | 11189471568 | 33 | 3375690 | 102293.6364 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 812904576 | 54193392 | 753291792 | 0 | 0 | 812904576 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 727346928 | 145469280 | 699083088 | 701397840 | 0 | 25949088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 713988000 | 178497000 | 655987200 | 659873808 | 0 | 54114192 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 314972592 | 104990688 | 301219776 | 301219776 | 0 | 13752816 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 252641664 | 84213888 | 228979872 | 0 | 0 | 252641664 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 45763872 | 15254448 | 36390816 | 0 | 6997584 | 38766288 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 30267600 | 15133800 | 28407984 | 0 | 0 | 30267600 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|