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 | 832 | 4873634147184 | 5857733112 | 140943293568 | 1210528176 | 88879598016 | 4783544020992 | 8 | 70656 | 8832.0000 | 486 | 431104 | 887.0453 | |
innodb/innodb_data_file | 2877 | 3538477985856 | 1229919240 | 246919293984 | 255604485840 | 43850480256 | 3239023019760 | 1399 | 28033024 | 20037.9014 | 1038 | 42418176 | 40865.2948 | |
innodb/innodb_temp_file | 260 | 1025621959296 | 3944699616 | 317259742800 | 0 | 378986749152 | 646635210144 | 0 | 0 | 0.0000 | 185 | 4669440 | 25240.2162 | |
sql/binlog | 295 | 190364932032 | 645304704 | 23592190512 | 1348682544 | 2330945232 | 186685304256 | 66 | 860 | 13.0303 | 12 | 4329 | 360.7500 | |
sql/binlog_index | 38 | 55286992464 | 1454920632 | 31654334976 | 762641616 | 0 | 54524350848 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 33789197376 | 519833688 | 2866908000 | 19265624928 | 0 | 14523572448 | 39 | 3989867 | 102304.2821 | 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 | 6 | 702888912 | 117148152 | 642055392 | 0 | 0 | 702888912 | 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 |
|