MySQL

Articles
MySQL

How to Partition MySQL Tables

Would it be strange to eat a whole pizza, starting from the crust and working your way inward? Similar to slicing a pizza before eating it, table partitioning is the process of dividing huge tables into smaller tables so that data can be more easily and efficiently queried.

By Oluwatomisin Bamimore
a year ago
Performance public

The Basics of MySQL Query Caching

MySQL's Query Cache is incredibly versatile. It’s usually able to store a wide variety of values and return them from the memory (rather than the disk) to improve query execution times. This guide will explore the usages and limitations of query caching.

By Lukas Vileikis
a year ago