Some limitations of partitioning in MySQL 5.1 on one page.

• All columns used in the partitioning expression for a partitioned table must be part of every unique key that the table may have.These rules also apply to existing nonpartitioned tables that you wish to partition.
• Partitioning applies to all data and indexes of a table; you cannot partition only the data and not the indexes, or vice versa, nor can you partition only a portion of the table.
• Prior to MySQL 5.1.43, it was not possible to partition a table by RANGE based on the value of a TIMESTAMP column by using the UNIX_TIMESTAMP() function.
• When partitioning by LIST, you can match variable against only a list of integers values and some time NULL but not with char values. Never tried partition with string, it will not work.
• If you explicitly define any subpartitions using SUBPARTITION option on any partition of a …