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 | 615 | 3703150849200 | 6021383280 | 125301361680 | 2019281616 | 175424482464 | 3525707085120 | 8 | 70656 | 8832.0000 | 357 | 321024 | 899.2269 | |
innodb/innodb_data_file | 2715 | 3126376652256 | 1151519688 | 260660506656 | 295994656848 | 39460230480 | 2790921764928 | 1475 | 29278208 | 19849.6325 | 843 | 36225024 | 42971.5587 | |
innodb/innodb_temp_file | 102 | 437574890544 | 4289949840 | 24801586128 | 0 | 2794595232 | 434780295312 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | |
sql/binlog | 273 | 120097529904 | 439917456 | 21853244160 | 1240545504 | 1649844768 | 117207139632 | 63 | 848 | 13.4603 | 7 | 1356 | 193.7143 | |
sql/binlog_index | 38 | 61331483664 | 1613986176 | 37514586912 | 1606818048 | 0 | 59724665616 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 25011427584 | 416857056 | 2731288560 | 16841329296 | 0 | 8170098288 | 36 | 3687708 | 102436.3333 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 10412791488 | 1301598936 | 7964328240 | 1999236624 | 0 | 8413554864 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 32 | 3901933200 | 121935264 | 3157809600 | 61896384 | 496134144 | 3343902672 | 8 | 701012 | 87626.5000 | 14 | 701012 | 50072.2857 | |
myisam/kfile | 4 | 1552366464 | 388091616 | 1530173040 | 1531978800 | 0 | 20387664 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 927632112 | 61842000 | 867464928 | 0 | 0 | 927632112 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 9 | 720702048 | 80077800 | 539217888 | 24196656 | 0 | 696505392 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 549066144 | 109813176 | 533476416 | 534818592 | 0 | 14247552 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 192570048 | 64190016 | 175476576 | 175476576 | 0 | 17093472 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 53173824 | 13293456 | 15983616 | 0 | 0 | 53173824 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 52214976 | 17404992 | 39898320 | 0 | 9436416 | 42778560 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 8802816 | 4401408 | 8441664 | 0 | 0 | 8802816 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|