Klaud hi i often got database error and have to restart server in order for mysql to back online how to optimize settings aapanel for VPS with 2 Core CPU and 4 GB RAM? here are my current settings:
Klaud i just face this problem again, and have restarted server, after server restart back to normal then i check current status:
idflorin You can increase max_connections a little bit (225) and table open cache to 512. Also, install MySQL tuner https://www.linode.com/docs/databases/mysql/how-to-optimize-mysql-performance-using-mysqltuner/ step 3 for aapanel is: "perl mysqltuner.pl --user root --pass YOURMYSQLDPASSWORD --mysqladmin /www/server/mysql/bin/mysqladmin"
Klaud idflorin thanks, I just set max_connections to (225) and table open cache to (512), lets see how it goes so I just run perl mysqltuner.pl --user root --pass YOURMYSQLDPASSWORD --mysqladmin /www/server/mysql/bin/mysqladmin from SSH?
idflorin Klaud login to ssh Download the MySQLTuner script: wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl Change the scripts permissions to be executable: chmod +x mysqltuner.pl Run the mysqltuner.pl script. perl mysqltuner.pl --user root --pass YOURMYSQLDPASSWORD --mysqladmin /www/server/mysql/bin/mysqladmin Follow MySQLTuner recomandations
aaPanel_Jose Klaud The maximum number of connections to your database is 200, but in fact you already have more than 200 connections, you can try to increase the number of connections in the optimization tab
