MySQL Forums
Forum List  »  Partitioning

Re: MYSQL 5.1 and partitioning
Posted by: Adrian Chapela Cordeiro
Date: July 17, 2008 05:51AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3622
July 14, 2008 05:20AM
Re: MYSQL 5.1 and partitioning
2519
July 17, 2008 05:51AM
2515
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.