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 | 534 | 3192716615616 | 5978870040 | 125301361680 | 2019281616 | 166927333584 | 3023770000416 | 8 | 70656 | 8832.0000 | 307 | 259584 | 845.5505 | |
innodb/innodb_data_file | 2612 | 2728562951136 | 1044625824 | 260660506656 | 295711376928 | 37569316224 | 2395282257984 | 1474 | 29261824 | 19851.9837 | 770 | 33964032 | 44109.1325 | |
innodb/innodb_temp_file | 102 | 437574890544 | 4289949840 | 24801586128 | 0 | 2794595232 | 434780295312 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | |
sql/binlog | 211 | 68218309104 | 323309448 | 21853244160 | 1201683120 | 1605093600 | 65411532384 | 49 | 792 | 16.1633 | 4 | 417 | 104.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/pid | 3 | 52214976 | 17404992 | 39898320 | 0 | 9436416 | 42778560 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 2 | 27049440 | 13524720 | 14405952 | 0 | 0 | 27049440 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 2 | 8802816 | 4401408 | 8441664 | 0 | 0 | 8802816 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|