Well, the table to be partitioned was around 70 GB of data, and on test I did the change took around 4 and a half days. In the test I got performance improvement as if I were querying 2000000 records and not 400 000 000.
Which partition method did you use? One of the method described below or something else?
From stackoverflow: ALTER TABLE table1 PARTITION BY KEY myINT11timestamp PARTITIONS 1000;
– or ALTER TABLE table1 PARTITION BY HASH (myINT11timestamp/1000) PARTITIONS 10;
Hi,
Was wondering how you ended up using partitions with unix timestamp based on your question on stackoverlow (http://stackoverflow.com/questions/7552700/mysql-partitioning-and-unix-timestamp)?
Thanks,
Jonathan
@Jonathan
Well, the table to be partitioned was around 70 GB of data, and on test I did the change took around 4 and a half days. In the test I got performance improvement as if I were querying 2000000 records and not 400 000 000.
Cheers
That’s pretty good.
Which partition method did you use? One of the method described below or something else?
From stackoverflow:
ALTER TABLE table1 PARTITION BY KEY myINT11timestamp PARTITIONS 1000;– or
ALTER TABLE table1 PARTITION BY HASH (myINT11timestamp/1000) PARTITIONS 10;I used
ALTER TABLE table1 PARTITION BY KEY myINT11timestamp PARTITIONS 1000;Cheers