Tuning MySQL 101: The Big Things to Look At
Database tuning is an art, rather than a science. I speak as someone who's worked as a professional DBA for over 15 years and is certified in multiple commercial RDBMS techologies. There is no set of formulas that can be presented that work in all cases, because the data sets and workloads are too variable. If we had a server with static data, unchanging server configuration, and known workloads, we could work out the ide...
Read More