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.
Thank you for your input. We will consider the possibility of implementing this feature in upcoming releases.
Fabio Perri commented
Hi, is a very very good idea !
Please add this feature to Plesk.
+1 for me.
Thanks in advance for the support.
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.