After reading part one and two of our Database Normalization and MySQL series, we could use a little follow up.In this article, we'll discuss those facets of optimizing a MySQL server that relate directly to it's compilation, configuration and subsequent administration.
As you’ve likely surmised over this lengthy article, there is quite a bit that you can do to increase the efficiency of MySQL, starting with the compilation of the database server, and continuing throughout the entire administration process. Of course, we didn’t even get into maximizing table-join efficiency, intelligent use of basic SQL queries, hardware considerations. However, I’ll be happy to discuss these matters in a later article, pending your interest. See you next time!
