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.
H.K
shared this idea
Thank you for your input. We will consider the possibility of implementing this feature in upcoming releases.
— ES
-
Goran Nešić commented
@fhsoft this is not new. Cpanel has done it for example with its mysql performance checker. Yes this should be in plesk.
-
fhsoft
commented
I know this wish will not be easy to implement and should be implemented as an add-on and to the previous beta test.
The automatic optimization would be good because of that +1 from me.
-
Bludau IT Services commented
+1
-
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.
-
Anonymous commented
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
1+
-
Anonymous
commented
Add an option to monitor external MySQL databases within Plesk and receive notifications
-
H50K
commented
^^^Yes, please...
And by the way do you perform joins without indexes ?
-
Webmeister
commented
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.
-
Rudy
commented
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.