SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 8100 | 40868776972848 | 5045527872 | 919435474320 | |
wait/io/file/innodb/innodb_data_file | 11685 | 14586577431888 | 1248316344 | 232021741776 | |
wait/io/file/innodb/innodb_temp_file | 442 | 927812148912 | 2099122344 | 35850292368 | |
wait/io/file/sql/binlog | 609 | 927403568784 | 1522830144 | 35429138448 | |
wait/lock/metadata/sql/mdl | 3 | 292396086048 | 97465361928 | 204532791936 | |
wait/io/table/sql/handler | 27033 | 78134145936 | 2890272 | 4318423296 | |
wait/io/file/sql/binlog_index | 38 | 47470518480 | 1249223976 | 29062866096 | |
wait/io/file/sql/ERRMSG | 80 | 44672602656 | 558407520 | 4029245088 | |
wait/io/file/sql/io_cache | 496 | 10307598576 | 20781288 | 693027984 | |
wait/lock/table/sql/handler | 3976 | 4415734752 | 1110384 | 416643744 | |
wait/io/file/csv/metadata | 8 | 3181118160 | 397639704 | 1977272880 | |
wait/io/file/mysys/cnf | 5 | 1649662080 | 329932416 | 1621887168 | |
wait/io/file/myisam/kfile | 8 | 1284808272 | 160600968 | 975839040 | |
wait/io/file/sql/casetest | 15 | 738594912 | 49239432 | 669116976 | |
wait/io/file/myisam/dfile | 6 | 601599504 | 100266408 | 564436224 | |
wait/io/file/csv/data | 17 | 401985408 | 23645952 | 263191632 | |
wait/io/file/mysys/charset | 3 | 246056448 | 82018728 | 234769920 | |
wait/io/file/sql/misc | 6 | 104542944 | 17423736 | 37932576 | |
wait/io/file/sql/pid | 3 | 49460400 | 16486800 | 38805360 |
|