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.
In Plesk Obsidian 18.0.54, published July 18th, 2023, the ability to tune the MySQL/MariaDB server performance was added to Tools & Settings > Performance Booster (under “General Settings”).
Please try it and let us know here what further improvements you would like to see.
Panel.ini did the job for me.
However, after running the optimizations that exceeded my server memory I was getting MySQL memory warnings. Not cool...seems I'm a better optimizer with MySQL Tuner.
M.K.'s suggestion is a good one, consider that.
The MySQL Performance Tuning option is just one out of many other options within the "Performance Booster" topic. If you do not see the "Performance Booster" topic, please add these two lines to your panel.ini file:
I also realized from comments that some users still use MariaDB 5.5. One step to increase performance strongly is to upgrade to MariaDB 10.6. It does not make much sense to optimize an old system (5.5) which is much slower than new MariaDB versions, so if you need more speed, first upgrade MariaDB, then optimize. For details please see https://support.plesk.com/hc/en-us/articles/12388091703703 .
@Memescape - I think we all understand where it's supposed to show up as an option. But, it seems, for most of us, it doesn't show up. I've even manually run "plesk daily" as Plesk staff recommended. Performance Booster option is still not showing up.
It's under Tools & Settings > General (see attached PerformanceBoost.png). When the extension loads, the MySQL performance settings are found under the Serverwide tab (see attached Serverwide.png). It's a little unobvious to find.
It's been 24 hours, and I'm not setting anything.
Waited for Plesk to run overnight tasks, still not seeing Performance Booster. Run plesk daily manually... still no Performance Booster.
Are you guys sure this feature is active in 18.0.54...? :-) CentOS 7, MariaDB 5.5 (stock Plesk install)
Sven Wappler commented
Thank you! The optimization suggestions are now available. Maybe you can add this hint to wait to the release notes ;-)
If you do not see the new MySQL/MariaDB yet, please either wait until tomorrow when the nightly maintenance was done or run "plesk daily" manually.
Robin Labadie commented
I do see the feature (Debian 11/MariaDB 10.6.14, no Nginx), but no MySQL settings are available.
Edit: My bad, auto update didn't happen, I was still in 18.0.53 😅
Would be great if:
- More settings were available
- We could selectively activate some optimizations and not others
- We could customize settings values from Plesk interface, but still see the recommended value
- Added information boxes in order to explain what the value does and what are the risks (for example, innodb_flush_method = O_DIRECT_NO_FSYNC will go bad when using XFS)
Updated Plesk to 18.0.54... the Performance Booster option is not showing up under General Settings (or anywhere else under Tools & Settings). Do you have to enable this somehow?
I have also updated to Plesk 18.0.54 and I see nothing in General Settings for this new feature. I even ran a 'plesk repair all' without any change.
Pascal DEVIF commented
I've updated Plesk to 18.0.54 and no changes in performance Booster.
Nothing for database.
Daniel González commented
I've updated Plesk and now there's a blank screen on Tools & Settings > Performance Booster...
@sven is right, at the moment it does not seem to be visible.
Sven Wappler commented
Hi! In updated to Plesk 18.0.54 but I cannot find anything about MySQL/MariaDB Server performance in "Performance Booster"
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.
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
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.