Idea
Create CLI tools to investigate database issues.
It should be an easy way to get information about the database:
- version/flavour
- important variables (vs. recommended ones?)
- table/index size
- fragmentation
- cluster info
- buffer pool hit-rate/query cache
- indices usage (used/unused)
- see current locks and blocked queries
Why
A lot of our performance issues are related to database performance. It should help admins to troubleshoot issues quicker.
Idea
Create CLI tools to investigate database issues.
It should be an easy way to get information about the database:
Why
A lot of our performance issues are related to database performance. It should help admins to troubleshoot issues quicker.