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 | 594 | 3460794237648 | 5826252696 | 106230393456 | 1575414720 | 108401278656 | 3350817544272 | 8 | 70656 | 8832.0000 | 349 | 362496 | 1038.6705 | |
innodb/innodb_data_file | 2424 | 2544767680752 | 1049821608 | 241956308352 | 220363194480 | 28980904128 | 2295423582144 | 1278 | 26050560 | 20383.8498 | 795 | 34979840 | 43999.7987 | |
innodb/innodb_temp_file | 180 | 972339100656 | 5401883784 | 224275667616 | 0 | 231583186032 | 740755914624 | 0 | 0 | 0.0000 | 102 | 3506176 | 34374.2745 | |
sql/binlog | 1193 | 337301663952 | 282733968 | 23083906032 | 2100405648 | 2897830320 | 332303427984 | 286 | 1740 | 6.0839 | 21 | 4769 | 227.0952 | |
sql/binlog_index | 38 | 44971505568 | 1183460520 | 25744174368 | 352093104 | 0 | 44619412464 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 30228260304 | 604565016 | 4531554720 | 15226844688 | 0 | 15001415616 | 30 | 3061174 | 102039.1333 | 0 | 0 | 0.0000 | |
sql/io_cache | 100 | 3350396016 | 33503712 | 783818112 | 227505696 | 1403257680 | 1719632640 | 36 | 2515640 | 69878.8889 | 44 | 2515640 | 57173.6364 | |
sql/casetest | 15 | 805404336 | 53693376 | 740598144 | 0 | 0 | 805404336 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 799258416 | 159851472 | 779889264 | 781586256 | 0 | 17672160 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 313783008 | 104594160 | 299232384 | 299232384 | 0 | 14550624 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 162935520 | 40733880 | 91431120 | 0 | 0 | 162935520 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 57333408 | 19110960 | 37477440 | 0 | 16651536 | 40681872 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|