SELECT * FROM `x$io_global_by_wait_by_bytes`
|
event_name | total | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 2668 | 2031470220384 | 0 | 761420616 | 73965088032 | 1587 | 32145408 | 20255.4556 | 631 | 29310976 | 46451.6260 | 61456384 | |
sql/io_cache | 980 | 126392642640 | 0 | 128971920 | 27552732768 | 476 | 23626396 | 49635.2857 | 394 | 23626396 | 59965.4721 | 47252792 | |
innodb/innodb_temp_file | 669 | 965613111936 | 0 | 1443367728 | 36856703664 | 0 | 0 | 0.0000 | 567 | 12697600 | 22394.3563 | 12697600 | |
sql/ERRMSG | 75 | 37157840016 | 2172720 | 495437712 | 3916135872 | 45 | 4606011 | 102355.8000 | 0 | 0 | 0.0000 | 4606011 | |
innodb/innodb_log_file | 438 | 2349646726416 | 228096 | 5364490032 | 46707145584 | 8 | 70656 | 8832.0000 | 246 | 230912 | 938.6667 | 301568 | |
sql/binlog | 545 | 85263820752 | 0 | 156447192 | 22485771264 | 136 | 52047 | 382.6985 | 6 | 974 | 162.3333 | 53021 | |
mysys/charset | 3 | 182858016 | 1090320 | 60952584 | 174340320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog_index | 23 | 2658445152 | 0 | 115584480 | 1612268064 | 5 | 224 | 44.8000 | 0 | 0 | 0.0000 | 224 | |
mysys/cnf | 5 | 1201346256 | 178992 | 240269040 | 1184068512 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 44900592 | 2458896 | 14966688 | 35302608 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 | 5 | |
sql/casetest | 15 | 888021024 | 0 | 59201208 | 831639072 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 193837248 | 0 | 64612416 | 177085392 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|