Archive for the ‘MySQL’ Category:
Easy way to optimize apache,php & MySQL
February 2nd, 2010 No Comments Posted in MySQL, PHP, System Administration, Web hosting, cpanel
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.
More »
How to move MySQL to second drive
January 6th, 2010 No Comments Posted in MySQL, Web hosting
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
More »