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 | 656 | 3828830460576 | 5836631592 | 39801278352 | 1186667328 | 74705659248 | 3752938134000 | 8 | 70656 | 8832.0000 | 378 | 322560 | 853.3333 | |
innodb/innodb_data_file | 2655 | 3266234379936 | 1230219936 | 260441124768 | 255292850736 | 45174542688 | 2965766986512 | 1385 | 27803648 | 20074.8361 | 863 | 36880384 | 42735.0915 | |
innodb/innodb_temp_file | 117 | 569635023408 | 4868675328 | 32472811008 | 0 | 3072656928 | 566562366480 | 0 | 0 | 0.0000 | 48 | 2031616 | 42325.3333 | |
sql/binlog | 253 | 144353643456 | 570567624 | 40088144448 | 1724859840 | 5582217168 | 137046566448 | 58 | 828 | 14.2759 | 7 | 1023 | 146.1429 | |
sql/binlog_index | 38 | 60771590880 | 1599252336 | 34783406592 | 1327220928 | 0 | 59444369952 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 41054387088 | 631605744 | 3269353824 | 22266629088 | 0 | 18787758000 | 39 | 3981890 | 102099.7436 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 2607247104 | 217270416 | 1695112320 | 2557629360 | 0 | 49617744 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1048923744 | 209784696 | 1010512272 | 1012752576 | 0 | 36171168 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 964868784 | 64324392 | 904510992 | 0 | 0 | 964868784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 219 | 730476384 | 3335376 | 335112624 | 595816320 | 0 | 134660064 | 150 | 18996 | 126.6400 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 297963600 | 99321024 | 285519696 | 285519696 | 0 | 12443904 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 52336416 | 17445384 | 41090544 | 0 | 8273232 | 44063184 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 3 | 35614656 | 11871552 | 13568544 | 0 | 0 | 35614656 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|