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