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 | 661 | 4224954053232 | 6391761024 | 480008381952 | 1073523792 | 129804383280 | 4094076146160 | 8 | 70656 | 8832.0000 | 380 | 295936 | 778.7789 | |
innodb/innodb_data_file | 2674 | 3212655168096 | 1201441560 | 253303026240 | 285179446992 | 44375323344 | 2883100397760 | 1420 | 28377088 | 19983.8648 | 809 | 34914304 | 43157.3597 | |
innodb/innodb_temp_file | 143 | 678847139520 | 4747182792 | 40455439728 | 0 | 3411535248 | 675435604272 | 0 | 0 | 0.0000 | 68 | 2752512 | 40478.1176 | |
sql/binlog_index | 38 | 45848057904 | 1206527784 | 22550483472 | 503873040 | 0 | 45344184864 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 38144324064 | 693533016 | 3358478112 | 23466567696 | 0 | 14677756368 | 33 | 3380492 | 102439.1515 | 0 | 0 | 0.0000 | |
sql/binlog | 193 | 36841389024 | 190887840 | 16678869504 | 725295648 | 41899440 | 36074193936 | 45 | 776 | 17.2444 | 3 | 156 | 52.0000 | |
csv/metadata | 8 | 2043745440 | 255468048 | 1237815216 | 709365360 | 0 | 1334380080 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 971202144 | 64746792 | 908271408 | 0 | 0 | 971202144 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 30 | 755378448 | 25179264 | 260320368 | 52258272 | 283232400 | 419887776 | 8 | 557824 | 69728.0000 | 12 | 549076 | 45756.3333 | |
myisam/kfile | 4 | 578539632 | 144634776 | 561688512 | 563817408 | 0 | 14722224 | 2 | 462 | 231.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 447925632 | 89584968 | 427234368 | 428765568 | 0 | 19160064 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 15 | 364354320 | 24290112 | 263711184 | 27651360 | 0 | 336702960 | 5 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 233086656 | 77695464 | 219988560 | 219988560 | 0 | 13098096 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46983552 | 15661008 | 37026528 | 0 | 7612176 | 39371376 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 4 | 17023248 | 4255680 | 11006688 | 0 | 0 | 17023248 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 1 | 13314576 | 13314576 | 13314576 | 0 | 0 | 13314576 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|