Re: MYSQL 5.1 and partitioning
There is no way to install partitioning in 5.0 but if you need partitioning, you can implement by yourself with merge tables and parts of tables. I have a table divided in days of month and I can do a delete of a day very fast.
Merge has bad performance if you do many queries on it but you can select the part in your app and then you will execute a query only in a part of the merge.
For production MySQL 5.1 isn't ready. I will wait until a GA version will be available.
Subject
Views
Written By
Posted
3768
July 14, 2008 05:20AM
Re: MYSQL 5.1 and partitioning
2594
July 17, 2008 05:51AM
2598
July 17, 2008 08:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.