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 | 1129 | 6452723764080 | 5715432888 | 140943293568 | 1210528176 | 121294670640 | 6330218565264 | 8 | 70656 | 8832.0000 | 666 | 666624 | 1000.9369 | |
innodb/innodb_data_file | 3333 | 4793200724928 | 1438103832 | 246919293984 | 256489981440 | 57080964336 | 4479629779152 | 1403 | 28098560 | 20027.4840 | 1376 | 53297152 | 38733.3953 | |
innodb/innodb_temp_file | 550 | 1182528181296 | 2150051112 | 317259742800 | 0 | 387254191632 | 795273989664 | 0 | 0 | 0.0000 | 466 | 9863168 | 21165.5966 | |
sql/binlog | 364 | 282867744720 | 777109080 | 23592190512 | 1691443248 | 4483722144 | 276692579328 | 81 | 1067 | 13.1728 | 18 | 5823 | 323.5000 | |
sql/binlog_index | 38 | 55286992464 | 1454920632 | 31654334976 | 762641616 | 0 | 54524350848 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 70 | 35531210352 | 507588576 | 2866908000 | 20222809200 | 0 | 15308401152 | 42 | 4296334 | 102293.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 1980479424 | 495119856 | 1557561984 | 1557561984 | 0 | 422917440 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 10 | 1787370816 | 178736976 | 1497105984 | 1740509232 | 15652560 | 31209024 | 4 | 834 | 208.5000 | 2 | 151 | 75.5000 | |
mysys/cnf | 5 | 1494290160 | 298858032 | 1477556256 | 1478684064 | 0 | 15606096 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 772569072 | 51504552 | 698035536 | 0 | 0 | 772569072 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 7 | 713907216 | 101986632 | 642055392 | 0 | 0 | 713907216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 330664224 | 110221320 | 311069616 | 311069616 | 0 | 19594608 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 4 | 188652288 | 47163072 | 172217232 | 0 | 172217232 | 16435056 | 0 | 0 | 0.0000 | 1 | 32 | 32.0000 | |
csv/data | 2 | 58071552 | 29035776 | 43232640 | 0 | 0 | 58071552 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 21537648 | 7179216 | 17123568 | 0 | 3262512 | 18275136 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|