Partitioning MySQL: Why, When, How?

If you are familiar with MySQL, you have probably heard of partitions. Partitions are one of your best friends in regards to query optimization. This article will provide you with a basic overview of partitions to help you understand why they are so important.

By Lukas Vileikis
a month ago

MySQL: Understanding EXPLAIN

If you have found yourself in the MySQL world (at least for a little while), chances are that you have probably heard about the usage of EXPLAIN. In the MySQL world, this keyword is everywhere.

By Lukas Vileikis
2 months ago