MySQL Forums
Forum List  »  Partitioning

Re: make number of partitions variable
Posted by: Mat private
Date: June 03, 2008 02:32AM

Hi Phil (and others),

I''ve changed the PK to (id,dbtime) and executed this query:

alter table tickdata.ratioticks
partition by range (dbtime)
(
partition p0 values less than (20080528000000),
partition p1 values less than (20080529000000),
partition p2 values less than (20080530000000),
partition p3 values less than (20080602000000),
partition p4 values less than maxvalue
);

there where no errors and the table seems to be partitioned well. But some queries take forever to be executed (especially one SP I just made: please see the threat: http://forums.mysql.com/read.php?98,212182,212182#msg-212182 I had to stop this one from execution) and others don't show any speed improvement at all.

I thought queries would be faster if a table would be partitioned? (what is the best we to unpartition without loosing data?).
Kind regards,

Matthijs

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: make number of partitions variable
2960
June 03, 2008 02:32AM


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.