A message for Linux.com registered users: We are in the process of making changes to the Linux forums. Starting Monday, 8/13/18 at 6:00 PM PT, you will be unable to access the forums. They will re-launch as soon as possible on Wednesday, 8/15/18 with new features and improved functionality. Thank you for your patience and stay tuned for the new improved forums.

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!