Computers are still a somewhat blackart to many people. Often, where it exists, the documentation can be impenitratable and few geeks want to change that. Its the old job security concept. I want to change that.
In this site you will find articles and links on various subjects; mostly Linux, Open Source and Programming related, but not exclusively. If you have any suggestions for articles or require expansion of any points in the articles, please feel free to contact me at this email address and I'll try to accommodate you.
Optimising MySQL
By Flib
2009-05-11
Category: MySQL
Many times you find that as you grow the bottleneck becomes the database. While you can scale out across multiple machines in many ways, for many people this just isn't an option.
In this article I try to explain a few ways to optimise your MySQL use to allow you to squeeze just a little more work from it before you have to scaleup to a bigger server or scaleout to many servers.