MySQL Forums
Forum List  »  Data Warehouse

Need advice for table rotation
Posted by: Pichai Iamtana-anan
Date: July 31, 2012 02:12AM

I plan to design system for keep access log in my customer website and keep every events that happen so data increase very quick (someday about 2M in 1 day)
and cause it is a log record that no need for update or delete, just select and insert. And We wanna keep data just 1 year, older than will be removed but cleaning process will not run everyday, may 1 week, 2 week or month once.
I plan to active data just only newest 3 months and archive 9 older months, is case customer wanna review and compare old data.
So please suggest me.
1. Which storage engine that I should use, myisam, innodb or archive engine?
2. If I split data to daily table or monthly table, How is it performance?
3. If you have any good idea, please tell me.

Thanks for every answer.

Options: ReplyQuote


Subject
Views
Written By
Posted
Need advice for table rotation
3863
July 31, 2012 02:12AM
1838
July 31, 2012 09:54PM


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.