Input Suggestion: Automatic optimization of MySQL/MariaDB settings

[Sven Wappler]

Hello,
my experience is that most of the problems with inaccessible webs on a Plesk system are related to the MySQL server.
Especially on VPS or cloud servers that can be scaled, the MySQL server does not adapt to the requirements. It could use much more RAM, but it doesn't. I had to manually increase the innodb_buffer_pool_size. Also, depending on the grown size, systems can serve a higher number of max_connections. Not doing so results in slow sites and "502 bad gateway" timeouts.
It would be super helpful if Plesk would periodically scan the settings and match them with what is possible. I think this will lead to a much more reliable system for some people.

 

[Maarten.]

You can vote for this feature request:

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...

plesk.uservoice.com