Improving the performance of a system using the MySQL database server is not just about indexes and buffers - getting the most out of the system requires a wider view. We’ll start by looking at what needs to be considered when a system starts needing work to maintain or improve performance. (more…)

Without wishing to sound pedantic, they’re indexes build upon a prefix of the column’s data. (more…)