How to Install PHP5.4 and MariaDB 5.5 on Debian 6.x Squeez

 In this tutorial, I will explain "How to Install PHP5.4 and MariaDB 5.5 on Debian 6.x Squeez?" MariaDB is a drop-in replacement for MySQL. MariaDB strives to be the logical choice for database professionals looking for a robust, scalable, and reliable SQL server. MariaDB provide repository for all famous linux distros. I'm going to use MariaDB repo for Debian 6.x Edit … [Read more...]

I get the error: “Could not connect to SQL database. Too many connections”.

Symptoms Sometimes I get the "Too many connections" error in Plesk CP or when open a site in my browser: [crayon-5ad89f91d5980850673828/] 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 … [Read more...]

Easy way to optimize apache,php & MySQL

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. [crayon-5ad89f91d5e69860943668/] … [Read more...]

How to move MySQL to second drive

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 … [Read more...]