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 | 2576 | 13238274274368 | 5139081552 | 474864963408 | 1285147248 | 379061639616 | 12857927487504 | 8 | 70656 | 8832.0000 | 1645 | 2856448 | 1736.4426 | |
innodb/innodb_data_file | 3737 | 7162812773424 | 1916727912 | 391426430736 | 208670065824 | 71499760992 | 6882642946608 | 1283 | 26132480 | 20368.2619 | 1653 | 62636032 | 37892.3364 | |
sql/binlog | 367 | 917452233456 | 2499869592 | 35992796400 | 642383808 | 1745786064 | 915064063584 | 58 | 828 | 14.2759 | 64 | 25047 | 391.3594 | |
innodb/innodb_temp_file | 114 | 523247449296 | 4589889744 | 41964190224 | 0 | 1402873296 | 521844576000 | 0 | 0 | 0.0000 | 46 | 1933312 | 42028.5217 | |
sql/binlog_index | 38 | 48391141392 | 1273450992 | 32089062720 | 215902896 | 0 | 48175238496 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 34412694096 | 573544752 | 2191385856 | 18631956816 | 0 | 15780737280 | 36 | 3692520 | 102570.0000 | 0 | 0 | 0.0000 | |
sql/SDI | 27 | 10889037984 | 403297488 | 9707375568 | 0 | 122746800 | 10766291184 | 0 | 0 | 0.0000 | 7 | 25377 | 3625.2857 | |
sql/misc | 11 | 2036836560 | 185166960 | 1887716688 | 0 | 0 | 2036836560 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 46 | 809535936 | 17598504 | 57399936 | 85256160 | 473902176 | 250377600 | 16 | 1080488 | 67530.5000 | 20 | 1080488 | 54024.4000 | |
sql/casetest | 15 | 782550384 | 52169832 | 714691824 | 0 | 0 | 782550384 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 670925904 | 134185128 | 648255168 | 649596288 | 0 | 21329616 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 293538432 | 97846056 | 280536960 | 280536960 | 0 | 13001472 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12849408 | 4283136 | 10474464 | 0 | 1748208 | 11101200 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|