SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 634 | 3753703193328 | 5920667280 | 75937458432 | |
wait/io/file/innodb/innodb_data_file | 2800 | 3403844838768 | 1215658752 | 245695236864 | |
wait/io/file/innodb/innodb_temp_file | 166 | 964572408096 | 5810676960 | 92112341376 | |
wait/io/table/sql/handler | 8213 | 61833148080 | 7528488 | 4769882304 | |
wait/io/file/sql/binlog | 313 | 61464594576 | 196372440 | 20757281424 | |
wait/io/file/sql/binlog_index | 38 | 53801118096 | 1415818800 | 27242278272 | |
wait/io/file/sql/ERRMSG | 65 | 44951222448 | 691557240 | 3273203472 | |
wait/io/file/mysys/cnf | 5 | 4648110720 | 929622144 | 4629389424 | |
wait/lock/table/sql/handler | 1908 | 2115046560 | 1108272 | 39444240 | |
wait/io/file/myisam/kfile | 4 | 1647015744 | 411753936 | 1584545424 | |
wait/io/file/sql/casetest | 15 | 773458752 | 51563688 | 710224944 | |
wait/io/file/csv/metadata | 8 | 752658192 | 94082208 | 416879760 | |
wait/io/file/mysys/charset | 3 | 259995648 | 86665128 | 247709088 | |
wait/io/file/sql/pid | 3 | 45424368 | 15141456 | 35559744 | |
wait/io/file/myisam/dfile | 2 | 32577072 | 16288536 | 30693168 | |
wait/io/file/csv/data | 4 | 30941856 | 7735464 | 9414768 | |
wait/io/file/sql/misc | 1 | 13677312 | 13677312 | 13677312 |
|