MySQL Forums
Forum List  »  Partitioning

Re: Partitioning on existing table
Posted by: m z
Date: November 05, 2009 08:45PM

It seems to me like you did not research partitioning at all - read this chapter first; http://dev.mysql.com/doc/refman/5.1/en/partitioning.html It has answers to all your questions.

60K rows is nothing. You need at the very least 100MB of data before you should even begin to start thinking about partitioning. If your queries are slow at 60K it's likely your table definition. You have indexes on fields used in aggregate functions, right?

Options: ReplyQuote


Subject
Views
Written By
Posted
4341
November 04, 2009 09:33PM
Re: Partitioning on existing table
2350
m z
November 05, 2009 08:45PM
2427
November 05, 2009 11:35PM
2291
November 06, 2009 01:17AM
2606
November 06, 2009 10:49AM


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.