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:
Hello Klaud Could you show me the mysql error messages?
this often happens on all website, i have to restart server to make it normal again.
i just face this problem again, and have restarted server, after server restart back to normal then i check current status:
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"
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?
perl mysqltuner.pl --user root --pass YOURMYSQLDPASSWORD --mysqladmin /www/server/mysql/bin/mysqladmin
Klaud
login to ssh
Download the MySQLTuner script: wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl
wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl
Change the scripts permissions to be executable: chmod +x mysqltuner.pl
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
wow thanks, i'll try that 😄
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
ho do i locate my mysqld root password?
desvampire On the database page of the panel