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 | 689 | 4141025116272 | 6010196016 | 125301361680 | 2019281616 | 186607655520 | 3952398179136 | 8 | 70656 | 8832.0000 | 399 | 350208 | 877.7143 | |
innodb/innodb_data_file | 2759 | 3278142868704 | 1188163416 | 260660506656 | 297989811504 | 40541331600 | 2939611725600 | 1476 | 29294592 | 19847.2846 | 876 | 37208064 | 42474.9589 | |
innodb/innodb_temp_file | 102 | 437574890544 | 4289949840 | 24801586128 | 0 | 2794595232 | 434780295312 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | |
sql/binlog | 311 | 140204937840 | 450819600 | 21853244160 | 1266091200 | 1691045664 | 137247800976 | 72 | 884 | 12.2778 | 8 | 1594 | 199.2500 | |
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 | 5 | 69242976 | 13848384 | 16069152 | 0 | 0 | 69242976 | 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 |
|