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 | 3395 | 18193650724656 | 5358954480 | 275769921504 | 1269729120 | 754455035664 | 17437925959872 | 8 | 70656 | 8832.0000 | 2164 | 2951680 | 1363.9926 | |
innodb/innodb_data_file | 5171 | 9943630745136 | 1922960688 | 293455665888 | 338854884720 | 169889670720 | 9434886189696 | 1581 | 31014912 | 19617.2751 | 2571 | 91996160 | 35782.2482 | |
sql/binlog | 855 | 2431374624624 | 2843712960 | 36272093616 | 2228991072 | 10867202544 | 2418278431008 | 127 | 1104 | 8.6929 | 170 | 58317 | 343.0412 | |
innodb/innodb_temp_file | 111 | 512874213984 | 4620488400 | 30567478656 | 0 | 3296296080 | 509577917904 | 0 | 0 | 0.0000 | 45 | 1785856 | 39685.6889 | |
sql/ERRMSG | 80 | 52127088816 | 651588432 | 4418422272 | 29298312912 | 0 | 22828775904 | 48 | 4912111 | 102335.6458 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 42213142224 | 1110872136 | 24221401776 | 953006208 | 0 | 41260136016 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 15285507072 | 1910688384 | 10825816848 | 2533668192 | 0 | 12751838880 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 2239868928 | 559967232 | 2007973968 | 0 | 0 | 2239868928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 1152526320 | 144065592 | 550711392 | 1106143104 | 0 | 46383216 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1042968960 | 69531264 | 985233216 | 0 | 0 | 1042968960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 667676592 | 133535160 | 637329792 | 639298704 | 0 | 28377888 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/dfile | 34 | 447279888 | 13155120 | 389407392 | 395186880 | 0 | 52093008 | 25 | 1675 | 67.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 274623888 | 91541208 | 264225456 | 264225456 | 0 | 10398432 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 8 | 127774944 | 15971736 | 32025312 | 0 | 0 | 127774944 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 22614240 | 7537992 | 15075984 | 0 | 6195552 | 16418688 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|