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 | 438 | 2349646726416 | 5364490032 | 46707145584 | 1490040288 | 41952538848 | 2306204147280 | 8 | 70656 | 8832.0000 | 246 | 230912 | 938.6667 | |
innodb/innodb_data_file | 2668 | 2031470220384 | 761420616 | 73965088032 | 240231685056 | 27586392768 | 1763652142560 | 1587 | 32145408 | 20255.4556 | 631 | 29310976 | 46451.6260 | |
innodb/innodb_temp_file | 666 | 941082262560 | 1413036240 | 36856703664 | 0 | 7523469888 | 933558792672 | 0 | 0 | 0.0000 | 565 | 12599296 | 22299.6389 | |
sql/io_cache | 980 | 126392642640 | 128971920 | 27552732768 | 3062331360 | 62329287504 | 61001023776 | 476 | 23626396 | 49635.2857 | 394 | 23626396 | 59965.4721 | |
sql/binlog | 545 | 85263820752 | 156447192 | 22485771264 | 5434299552 | 1521156912 | 78308364288 | 136 | 52047 | 382.6985 | 6 | 974 | 162.3333 | |
sql/ERRMSG | 75 | 37157840016 | 495437712 | 3916135872 | 18692677344 | 0 | 18465162672 | 45 | 4606011 | 102355.8000 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 2658445152 | 115584480 | 1612268064 | 1921458528 | 0 | 736986624 | 5 | 224 | 44.8000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1201346256 | 240269040 | 1184068512 | 1185016272 | 0 | 16329984 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 888021024 | 59201208 | 831639072 | 0 | 0 | 888021024 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 193837248 | 64612416 | 177085392 | 0 | 0 | 193837248 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 182858016 | 60952584 | 174340320 | 174340320 | 0 | 8517696 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 44900592 | 14966688 | 35302608 | 0 | 7139088 | 37761504 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|