Partitioning MySQL

This is purely for the sake of partitioning. In this example, I’ll quickly partition the wordpress comments table into partitions. The hash partition ensures data are evenly distributed across partitions. mysql> alter table wp_comments partition by hash(comment_ID) partitions 3; Query OK, 13 rows affected (0.04 sec) Records: 13 Duplicates: 0 Warnings: 0 Now check that queries are only reaching out to necessary partitions mysql> explain partitions select * from wp_comments…

Read More