HomeMySQL MySQL Query Optimizations and Schema Design
MySQL Query Optimizations and Schema Design
Performance is something for which we all strive. This applies to the lives of DBAs too, since their first and foremost task is to achieve a high level of performance from their databases. SQL professionals canít stress enough that spending quality time to optimize both schema design and queries should be considered top priorities. In this article we are going to cover these two.
This is the third segment of the MySQL Performance Optimization four-part article series. Before we begin, I urge you to go back and check out the earlier parts.
Within the first article, the most important benchmarking concepts and strategies were pointed out. The second segment presented benchmarking applications and other useful tools to apply what we have learned and test our own performance.
As promised, in this third article we're going to delve into optimizations and present most of the popular tips and hints regarding schema design and query optimizations. We need to grasp the concepts in order to be able to adapt them to your own needs (i.e.; database requirements).
Right after this part, the final part will cover really useful server tuning techniques and advice. Our purpose is to help you get the most out of your server.
Now that you already know what to expect from this segment, let's begin. Enjoy!