MySQL Slow Query Log in WHM Interface
Open Discussion
As a systems administrator, I would like to be able to turn on MySQL's slow query log through WHM so that I do not need to use the command line to track queries that take a long time to complete. I would also like to be able to review the log in WHM, possibly with some summary statistics, so that I can more easily find users who are using excessive resources with MySQL.
I like this idea 
cPanel, WebHost Manager and WHM are registered trademarks of cPanel, L.L.C. for providing its computer software that facilitates the management and configuration of Internet web servers.
I am strongly suggesting this feature some sort of automation in the following way
- Enable / Disable logging in WHM on a scheduled duration or forever. If scheduled, some sort of email logs to server admin (ideal)
- If Enabled, some options for like how long the logs are maintained for? Like if the administrator had setup logs forever, than ideally how many days the logs are maintained for (any logs before that delay is automatically truncated).
As a generic idea, its pretty good options for database specialists to analyze and fine tune the my.cnf files accordingly on the fly and quickly rather spending hours to first see where the things are going wrong and how the things can bring the speed down.
As an addition, I think some sort of user queries per 15 minutes (like cloud linux configuration) on non cloud linux installations are preferrably a good idea.
I am strongly suggesting this feature some sort of automation in the following way
- Enable / Disable logging in WHM on a scheduled duration or forever. If scheduled, some sort of email logs to server admin (ideal)
- If Enabled, some options for like how long the logs are maintained for? Like if the administrator had setup logs forever, than ideally how many days the logs are maintained for (any logs before that delay is automatically truncated).
As a generic idea, its pretty good options for database specialists to analyze and fine tune the my.cnf files accordingly on the fly and quickly rather spending hours to first see where the things are going wrong and how the things can bring the speed down.
As an addition, I think some sort of user queries per 15 minutes (like cloud linux configuration) on non cloud linux installations are preferrably a good idea.
Replies have been locked on this page!