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 | 1645 | 8819189903568 | 5361209568 | 117397966224 | 1563639792 | 393108964512 | 8424517299264 | 8 | 70656 | 8832.0000 | 1008 | 1196544 | 1187.0476 | |
innodb/innodb_data_file | 3901 | 5732145550560 | 1469403936 | 222961337808 | 556103915136 | 67178318592 | 5108863316832 | 1459 | 29016064 | 19887.6381 | 1742 | 65159168 | 37404.8037 | |
innodb/innodb_temp_file | 779 | 1311554807376 | 1683638880 | 49380453936 | 0 | 36070798896 | 1275484008480 | 0 | 0 | 0.0000 | 670 | 14843904 | 22155.0806 | |
sql/binlog | 261 | 343860079200 | 1317471408 | 24927301872 | 3957217968 | 2677493280 | 337225367952 | 51 | 800 | 15.6863 | 25 | 6592 | 263.6800 | |
sql/binlog_index | 38 | 58457567520 | 1538357040 | 41022546576 | 1494270624 | 0 | 56963296896 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 42959499264 | 660915288 | 14480776992 | 14968411392 | 0 | 27991087872 | 39 | 3985244 | 102185.7436 | 0 | 0 | 0.0000 | |
sql/io_cache | 503 | 25484566272 | 50665032 | 5881978080 | 1422643200 | 6482058000 | 17579865072 | 222 | 12425612 | 55971.2252 | 211 | 12425612 | 58889.1564 | |
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 | |
sql/misc | 8 | 343835184 | 42979200 | 267528096 | 0 | 0 | 343835184 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 277080144 | 92359872 | 237049824 | 237049824 | 0 | 40030320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 14126640 | 4708704 | 9380448 | 0 | 3822192 | 10304448 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|