January 27, 2010

MySQL and Apache tuning



My company has got a server with several databases running in it. Each of the database is at least 20MB in size or even more.
It uses MySQL server to run the databases of course, and Apache as the web server.

My question is, because of the increased databases, I assume more space is occupied in the MySQL server. is this correct?
So is it advisable to tune MySQL so that the performance would be better? Does the same go for Apache server?

When do I have to actually perform the tuning?

What type of performance tuning do I have to perform for 3 to 4 MySQL databases, each about 20 MB in size?

What if there were 10 - 20 databases of 20 MB sizes each/

Click Here!