It can be very easy to improve scalability with a MySQL server by a few simple rules. Here is one of them.
“The most efficient way to improve an SQL statement is to eliminate it”
There are numerous ways to eliminate SQL statements, however before I give a classic example that I’ve observed again with a client, let me explain the basic premise of why this improves scalability?
The MySQL kernel can only physically process a certain number of SQL statements for a given time period (e.g. per second). Regardless of the type of machine you have, there is a physical limit. If you eliminate SQL statements that are unwarranted and unnecessary, you automatically enable more important SQL statements to run. There are numerous other downstream affects, however this is the simple math. To run more SQL, reduce the number of SQL you need to run.
Here is the output of a small sample of analyzed TCP/IP …[Read more]