Partition Key

Partition Keys Can Make Unique Indexes Useless

by Ed Chen
November 25, 2015March 29, 2018

Normally, we build an unique index for protecting the table from inserting duplicate values of combined columns. If the constraint of the unique index is… Read More »

Partition Key is NOT Necessarily the First Key of Composite Indexes

by Ed Chen
June 26, 2015March 29, 2018

If you do believe that the arrangement of positions in a composite index really matters on the whole performance, here is another evidence for that.MySQL… Read More »

How to Use a Timestamp Column as a Partition Key

by Ed Chen
September 3, 2013May 17, 2019
2 Comments

Using a date or int column as a partition key is a lot easier than using a timestamp column in MySQL. Because the final datetime… Read More »

How to Resolve ERROR 1486 (HY000) in MySQL

by Ed Chen
July 27, 2013March 29, 2018

When we partitioned a table by a timestamp-typed column "order_time" in table "orders", it generated an error 1486 like this:mysql> ALTER TABLE orders PARTITION BY… Read More »