Tag: 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…