MySQL Forums
Forum List  »  Partitioning

IP vs Date Partition
Posted by: Tim Linden
Date: May 13, 2013 10:28AM

Hey Guys

I've started to use parititons and am seeing the speed benefits, but I'm unsure if I'm doing it the best way.

I'm tracking data on the last time an IP took an action. Right now to save space it simply updates the last time field and other data each time they do the action again. I'm then dumping any IPs that have been over 30 days.

My partition is currently based on IP address. Which has improved the speed in tracking, but I'm not benefiting from faster drop offs over that 30 days.

I'm hesistent to try partitioning based on date because then it's 30 partitions on each update to find that IP, and if it's been a few days and I update the record to today's date it's gotta move that record which adds more latency.

So your thoughts? Or am I overestimating how long it takes to check each partition or move data between them?



Options: ReplyQuote

Written By
IP vs Date Partition
May 13, 2013 10:28AM
May 14, 2013 09:59PM
May 15, 2013 10:06AM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.