This is another section that is broader than one would first imagine. There’s a reason that many large organizations employ dedicated database administrators. That said, this doesn’t prevent the average sysadmin from making some changes to enhance performance on their database.
The easiest way to start on this is to utilize a script to automatically check your configuration options and make suggestions based on status variables MySQL sets. I’ve had good luck with a script called mysqltuner.pl. You can[Read more...]