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_data_file | 1499 | 724560001790 | 483362120 | 286952272460 | 183133353370 | 12830723360 | 528595925060 | 1160 | 24117248 | 20790.7310 | 178 | 15745024 | 88455.1910 | |
innodb/innodb_log_file | 64 | 521392545600 | 8146758525 | 177760704150 | 1765321880 | 89378529020 | 430248694700 | 8 | 70656 | 8832.0000 | 31 | 59392 | 1915.8710 | |
innodb/innodb_temp_file | 90 | 407552177690 | 4528357365 | 57388033240 | 0 | 2191698930 | 405360478760 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog_index | 38 | 54225259300 | 1426980480 | 31173199210 | 1373683150 | 0 | 52851576150 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 45 | 49142947260 | 1092065265 | 23684783100 | 1223037540 | 47759360 | 47872150360 | 8 | 628 | 78.5000 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 20 | 16738326440 | 836916110 | 3627172130 | 9180025060 | 0 | 7558301380 | 12 | 1217942 | 101495.1667 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1789749580 | 357949810 | 1768181230 | 1769719820 | 0 | 20029760 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 856729630 | 57115185 | 791938190 | 0 | 0 | 856729630 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 285010150 | 95003295 | 270070510 | 270070510 | 0 | 14939640 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 63567670 | 21189135 | 37927860 | 0 | 22424830 | 41142840 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 3313560 | 3313560 | 3313560 | 0 | 0 | 3313560 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|