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 | 897 | 5180532401616 | 5775398376 | 106230393456 | 1575414720 | 145954699440 | 5033002287456 | 8 | 70656 | 8832.0000 | 530 | 513024 | 967.9698 | |
innodb/innodb_data_file | 3189 | 3388123560624 | 1062440544 | 241956308352 | 285826044768 | 42884794656 | 3059412721200 | 1548 | 30474240 | 19686.2016 | 1117 | 45039616 | 40321.9481 | |
innodb/innodb_temp_file | 222 | 1237771038240 | 5575545096 | 224275667616 | 0 | 232897508448 | 1004873529792 | 0 | 0 | 0.0000 | 130 | 4882432 | 37557.1692 | |
sql/binlog | 1651 | 451665287040 | 273570528 | 23083906032 | 2459780928 | 3730921392 | 445474584720 | 397 | 2184 | 5.5013 | 28 | 6425 | 229.4643 | |
sql/binlog_index | 38 | 44971505568 | 1183460520 | 25744174368 | 352093104 | 0 | 44619412464 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 33383081952 | 606965040 | 4531554720 | 17504726976 | 0 | 15878354976 | 33 | 3379956 | 102422.9091 | 0 | 0 | 0.0000 | |
sql/io_cache | 166 | 11794673616 | 71052168 | 7075395360 | 364602480 | 2335382544 | 9094688592 | 66 | 4074512 | 61735.0303 | 70 | 4074512 | 58207.3143 | |
myisam/dfile | 8310 | 4638380736 | 558096 | 379876992 | 4482872064 | 0 | 155508672 | 7302 | 492896 | 67.5015 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 1378620144 | 86163528 | 384269424 | 1302108192 | 0 | 76511952 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
csv/data | 2 | 890782464 | 445391232 | 884603808 | 0 | 0 | 890782464 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
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 | |
csv/metadata | 4 | 197422368 | 49355592 | 145050576 | 145050576 | 0 | 52371792 | 1 | 35 | 35.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 |
|