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 | 2314 | 12837552741552 | 5547775464 | 263690719248 | 1244340768 | 890975370384 | 11945333030400 | 8 | 70656 | 8832.0000 | 1391 | 1193472 | 857.9957 | |
innodb/innodb_data_file | 4880 | 5660371499376 | 1159911984 | 219411566352 | 415903675440 | 89705110704 | 5154762713232 | 1534 | 30244864 | 19716.3390 | 2717 | 96059392 | 35354.9474 | |
innodb/innodb_temp_file | 461 | 1713753983040 | 3717470592 | 433177047072 | 0 | 171629148240 | 1542124834800 | 0 | 0 | 0.0000 | 361 | 9191424 | 25461.0083 | |
sql/ERRMSG | 65 | 315158577888 | 4848593376 | 273601399104 | 19631670960 | 0 | 295526906928 | 39 | 3984361 | 102163.1026 | 0 | 0 | 0.0000 | |
sql/binlog | 325 | 165353047728 | 508778424 | 28166447232 | 2883785520 | 1983275184 | 160485987024 | 74 | 892 | 12.0541 | 11 | 2703 | 245.7273 | |
sql/io_cache | 874 | 68648731536 | 78545280 | 25841721840 | 2440198992 | 10723136688 | 55485395856 | 432 | 21174678 | 49015.4583 | 352 | 21174678 | 60155.3352 | |
sql/binlog_index | 38 | 65084208816 | 1712742240 | 30858444672 | 3389699280 | 0 | 61694509536 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 16428687264 | 2053585776 | 15271653936 | 727432464 | 0 | 15701254800 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 5312271888 | 664033920 | 4540468416 | 5241627600 | 0 | 70644288 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1197154992 | 79810104 | 1131872016 | 0 | 0 | 1197154992 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 553675056 | 110734800 | 534004944 | 535163904 | 0 | 18511152 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 17 | 480125184 | 28242456 | 206629632 | 34239216 | 0 | 445885968 | 5 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 204961680 | 68320560 | 191885232 | 191885232 | 0 | 13076448 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 7 | 59954928 | 8564952 | 33705408 | 0 | 0 | 59954928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 36274656 | 9068664 | 13061664 | 0 | 0 | 36274656 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13161984 | 4387152 | 10584816 | 0 | 1918752 | 11243232 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|