Question MYSQL variables available in Plesk

[Thomas Oryon]

Server operating system version

RHEL 9

Plesk version and microupdate number

18.0.67

Hello,

1. Can you please let us know the mysql variables available in Plesk?
2. Can you please let us know the limits we can set for mysql varaibales on plesk? Example wait_timeout,etc., with an description?
3. How can we change the limit for the mysql variables in Plesk?

Kindly let us know the above details regarding the MYSQL variables.

Awaiting your reply.

 

[Thomas Oryon]

What is the recommended value for the below MYSQL variables for 16GB RAM 32CORE CPU Linux server and it has 250 accounts?

+++
1. Max Connections (Global)
2. Max User Connections (Per User)
3. InnoDB Buffer Pool Size
4. Temporary Table Size
5. Thread Cache Size
6. Query Cache Size
7. Max Allowed Packet
8. Sort Buffer Size
9. Wait Timeout
+++

 

[Bitpalast]

There is no "one size fits all". There are some options to improve MySQL performance. You could try the performance optimizer in Plesk. It will apply a few settings to the database server that are known to improve the performance. For a more detailed approach, run "mysqltuner" (GitHub - major/MySQLTuner-perl: MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.). It will give you an insight into your individual real time server behavior, thus making it possible to find optimal values for specifically your server, your users' usage, your database load.

 

[Thomas Oryon]

Hello,

Can you please let us know the Approximate value at-least?

16GB RAM 32CORE CPU Linux server and it has 250 accounts.

+++
1. Max Connections (Global)
2. Max User Connections (Per User)
3. InnoDB Buffer Pool Size
4. Temporary Table Size
5. Thread Cache Size
6. Query Cache Size
7. Max Allowed Packet
8. Sort Buffer Size
9. Wait Timeout
+++

 

[Bitpalast]

There is no "one size fits all".