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 | 1050 | 6026258972448 | 5739294000 | 140943293568 | 1210528176 | 111822328464 | 5913226115808 | 8 | 70656 | 8832.0000 | 619 | 593408 | 958.6559 | |
innodb/innodb_data_file | 3193 | 4369970606496 | 1368609528 | 246919293984 | 256489981440 | 55629797520 | 4057850827536 | 1403 | 28098560 | 20027.4840 | 1270 | 49823744 | 39231.2945 | |
innodb/innodb_temp_file | 450 | 1111838337456 | 2470751712 | 317259742800 | 0 | 386440962864 | 725397374592 | 0 | 0 | 0.0000 | 370 | 8028160 | 21697.7297 | |
sql/binlog | 315 | 255890444304 | 812350440 | 23592190512 | 1660745856 | 4458498528 | 249771199920 | 69 | 872 | 12.6377 | 16 | 5336 | 333.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 |
|