cPanel & WHM Version 80 has been released, and brings a slew of great updates. Take a look at what is included, and then upgrade today!
 

MySQL Slow Query Log in WHM Interface

cPanelMary shared this idea 3 years ago
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.

Comments (1)

photo
2

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.