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