MySQL Optimizations

Partitioning MySQL partitioning is a concept with 2 contexts primarily the horizontal partitioning and the other being vertical partitioning. Partitioning of relational data, it usually refers to decomposing your tables or breaking your tables either row-wise (horizontally) or column-wise (vertically). Vertical partitioning, aka row splitting, uses the same splitting techniques as database normalization, but usually…