SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/sql/binlog | 983 | 1320224085312 | 1343055912 | 33099361152 | |
root | wait/io/file/innodb/innodb_temp_file | 130 | 1115412391632 | 8580095304 | 32375124672 | |
root | wait/io/file/innodb/innodb_data_file | 637 | 672673092432 | 1056001584 | 32539040688 | |
root | wait/io/file/sql/ERRMSG | 75 | 40696529808 | 542620320 | 3267547008 | |
root | wait/io/file/sql/io_cache | 182 | 9522053904 | 52318728 | 2852160432 | |
root | wait/io/table/sql/handler | 549 | 9011832192 | 16414992 | 1720543440 | |
root | wait/io/file/sql/misc | 28 | 683019744 | 24393336 | 237231456 | |
root | wait/io/file/csv/metadata | 8 | 639301344 | 79912536 | 210227952 | |
root | wait/lock/table/sql/handler | 355 | 467836512 | 1317624 | 14359488 | |
root | wait/io/file/myisam/kfile | 4 | 247708032 | 61927008 | 168037584 | |
root | wait/io/file/myisam/dfile | 4 | 227540544 | 56885136 | 200920368 | |
root | wait/io/file/csv/data | 4 | 50111952 | 12527856 | 28917504 | |
root | wait/io/file/sql/binlog_index | 2 | 7207728 | 3603864 | 5670192 |
|