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 | 1134 | 5962276577136 | 5257739256 | 102695888064 | 1344332880 | 250645595904 | 5710286648352 | 8 | 70656 | 8832.0000 | 696 | 982528 | 1411.6782 | |
innodb/innodb_data_file | 3161 | 4473179106528 | 1415114976 | 194651863824 | 192944423760 | 68337281232 | 4211897401536 | 1282 | 26116096 | 20371.3697 | 1333 | 52019200 | 39024.1560 | |
innodb/innodb_temp_file | 672 | 1372202962416 | 2041968456 | 451593983280 | 0 | 552373249296 | 819829713120 | 0 | 0 | 0.0000 | 587 | 11911168 | 20291.5980 | |
sql/binlog | 319 | 294811652784 | 924174240 | 28895986416 | 1722819120 | 4100142816 | 288988690848 | 68 | 868 | 12.7647 | 20 | 5363 | 268.1500 | |
sql/binlog_index | 38 | 56345363184 | 1482772632 | 28685321808 | 184998000 | 0 | 56160365184 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 28135100400 | 562702008 | 4986390816 | 15635935392 | 0 | 12499165008 | 30 | 3077212 | 102573.7333 | 0 | 0 | 0.0000 | |
sql/io_cache | 50 | 22098698688 | 441973752 | 21130458624 | 141315504 | 517311168 | 21440072016 | 18 | 1286688 | 71482.6667 | 22 | 1286688 | 58485.8182 | |
mysys/cnf | 5 | 1218536352 | 243707112 | 1191844896 | 1193067216 | 0 | 25469136 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 736376784 | 49091592 | 659538000 | 0 | 0 | 736376784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 211982496 | 52995624 | 191359344 | 193397952 | 0 | 18584544 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 182082384 | 60694128 | 168645840 | 168645840 | 0 | 13436544 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 53158512 | 13289496 | 21785808 | 0 | 0 | 53158512 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 15901248 | 5300328 | 10242672 | 0 | 4984320 | 10916928 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 10250064 | 5125032 | 9686160 | 0 | 0 | 10250064 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|