Back in March, I wrote about Partitioning in MySQL 5.1 not being usable, and since a few releases have gone out, and a few months have passed, I am re-visiting the issues I saw back then.
MySQL still doesn’t allow you to partition using a native DATE or DATETIME column. This is a major problem in my opinion, as it’s probably one of the most common uses for partitioning, but is only seen as a “feature request” by MySQL. Hopefully that will get fixed sometime in the near future.
I filed a couple more bugs today, the most serious of which was the inability to repair “crashed” partitions:
mysql> alter table ontime repair partition p_199609; ERROR 145 (HY000): Table './flightstats/ontime#P#p_199609' is marked as crashed and should be repaired
Here are the bugs I filed:
- Bug #20129: ALTER TABLE … REPAIR PARTITION … complains that partition is corrupt
- Bug #20130: ALTER TABLE … ADD PARTITION needs a force option
- Bug #20131: Partitioning by DATE/DATETIME doesn’t work
Partitioning still has quite a way to go before it’s really usable in my opinion, but it’s certainly improving!