I get ask, by application developers, “how do you optimize MySQL”. I do lots of things that don’t really relate to a developer. I analyze the percent of queries are being pulled from cache for instance. What a developer can do to optimize the SQL they develop is a different questions. So here is a [...]