MYSQL Performance Tuning and Monitoring
t would be a good idea to have an SQL section where users can run optimization scripts like MYSQLTUNER etc and enter suggestioned changes in a GUI that directly change the mysql.conf directly and correctly.
An ability to monitor performance and tweak would be ideal, making the task of SQL performance monitoring and tweaking far easier.
Also optimize commands and other tasks could be run for this panel.
as well as optimize and the ability to add it to cron for weekly or monthly.
MySQL Performance tuning has been available for more than half a year in the scope of the free Plesk Performance Booster feature (https://www.plesk.com/blog/product-technology/how-to-speed-up-your-website-by-30-tips-measure-performance-effectively/). Since July 2023 no new comments were added to this feature request. As no new requests were added, this feature is now considered "completed".
Please feel free to comment on this or open a new feature request in case your expectations are not met yet.
Excellent idea, each server has a unique hardware profile that makes tweaking the sql variables a must to achieve the best response times from the database. Everyone uses their database for a different task, requiring modification to the default settings. This would help enormously.
Kai Dold commented
Add an option to monitor external MySQL databases within Plesk and receive notifications
And by the way do you perform joins without indexes ?
Please add MySQL tuning, especially for modern hardware with 32 or 64 GB memory and 4 to 8 cores and fast SSD or NVMe drives. Thanks!
Madalin Ignisca commented
Tip for this: use MySQL Workbench and you can do a lot of optimizations.
It would be a good idea to be able to make some tunings to mysql configuration (my.cnf) as happens with php directives .
William Thompson commented
I like the feature to monitor the web log to see file execution as they come in and the PHP errors. It would be nice to have a similar tool to see the sql queries come in and see if there are any errors.