Symptoms
Sometimes I get the "Too many connections" error in Plesk CP or when open a site in my browser:
Unable to connect to database: Too many connections
Cause
This error means that the limit of simultaneous MySQL connection to mysql server is reached and new connections to the server cannot be established at this time.
Resolution
There are two ways to solve this issue. The first one is increase the connection limit and the... [ Continue reading... ]
There are 2 important scripts to optimize apache,php and mysql very easily. They are
MySQLTuner (Perl) and MySQL Performance Tuning Primer (shell)
They can help diagnose MySQL database performance issues, and provide recommendations on how to solve them.
# Download MySQLTuner and MySQL Performance Tuning Primer to ~/scripts.
# To avoid having to invoke Perl/SH each time, make both files executable.
chmod +x... [ Continue reading... ]
If you ran out of space in your primary drive and wish to move MySQL to another drive then here is a simple procedure. Moving MySQL to another drive is very easy then it look.
1) Find out mount point of secondary drive. If drive is not mounted yet then you can get help from article "How to mount drive in CentOS"
You can run below command to find mount point of secondary drive
df -h
It could be /dev/hdb or /dev/sdb and mount to (let... [ Continue reading... ]
