Partition Key Makes Unique Index Useless
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 Makes Unique Index Useless
Partitions
MySQL Partition by String Column
You might have known that LIST, RANGE, and HASH partitions all refuse to accept VARACHAR column as the native partition key. mysql> alter table locations… Read More »MySQL Partition by String Column
How to Resolve ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
ERROR 1217 (23000) Got a MySQL ERROR 1217 (23000) when tried to partition a table. mysql> alter table geolocations partition by ... ... ERROR 1217… Read More »How to Resolve ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
Partition Key is NOT Necessarily the First Key
Partition Key in Composite Index If you do believe that the arrangement of positions in a composite index really matters on the whole performance, here… Read More »Partition Key is NOT Necessarily the First Key
How to Resolve ERROR 1697 (HY000): VALUES value for partition must have type INT
ERROR 1697 (HY000) Using a date or int column as a partition key is a lot easier than using a timestamp column in MySQL. Because… Read More »How to Resolve ERROR 1697 (HY000): VALUES value for partition must have type INT
How to Resolve ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed
ERROR 1486 (HY000) When we partitioned a table by a timestamp-typed column ORDER_TIME in table ORDERS, it generated an error 1486 like this: mysql> ALTER… Read More »How to Resolve ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed