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 | 892 | 6092474223792 | 6830128008 | 838897722960 | 1258557696 | 119417973840 | 5971797692256 | 8 | 70656 | 8832.0000 | 523 | 546304 | 1044.5583 | |
innodb/innodb_data_file | 3089 | 4649816657376 | 1505282064 | 226166068128 | 219545314560 | 70279808544 | 4359991534272 | 1434 | 28606464 | 19948.7197 | 1143 | 45236224 | 39576.7489 | |
innodb/innodb_temp_file | 173 | 837413404608 | 4840539792 | 31099019424 | 0 | 3310427472 | 834102977136 | 0 | 0 | 0.0000 | 87 | 3784704 | 43502.3448 | |
sql/binlog | 599 | 317890325808 | 530701512 | 33840868512 | 1107596688 | 1713408048 | 315069321072 | 140 | 1450 | 10.3571 | 19 | 5133 | 270.1579 | |
sql/binlog_index | 38 | 48144605520 | 1266963192 | 26527038384 | 1600354272 | 0 | 46544251248 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 36946319520 | 615771816 | 2743260960 | 19413175584 | 0 | 17533143936 | 36 | 3686782 | 102410.6111 | 0 | 0 | 0.0000 | |
sql/io_cache | 54 | 6332838864 | 117274608 | 5248015872 | 98893872 | 701925840 | 5532019152 | 15 | 1219512 | 81300.8000 | 24 | 1219512 | 50813.0000 | |
csv/metadata | 8 | 5747596800 | 718449600 | 4983614592 | 5490753312 | 0 | 256843488 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 4518309312 | 282394200 | 2325390672 | 4440670080 | 0 | 77639232 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 818758512 | 54583848 | 735329232 | 0 | 0 | 818758512 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 10 | 683057232 | 68305512 | 406898448 | 0 | 0 | 683057232 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 670658208 | 134131536 | 647149536 | 648730896 | 0 | 21927312 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/dfile | 86 | 383715552 | 4461600 | 300388176 | 312200592 | 0 | 71514960 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 289004496 | 96334656 | 263645184 | 263645184 | 0 | 25359312 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 49664736 | 12416184 | 25246320 | 0 | 0 | 49664736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 15851616 | 5283696 | 12627120 | 0 | 2455200 | 13396416 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|