MySQL Forums
Forum List  »  Partitioning

Partitioning help
Posted by: Anantha Varatharajan
Date: September 24, 2010 02:16AM

Hi

I am new to mysql.I have a requirement of storing large data (text data - 10gb/hour) in a table and deleting it after few days. I am thinking of using partitioning feature for this. Can we create partitions (by day) on a partition? The insert time required is 0.05 sec all the time.Would it be possible?
Could you suggest which engine I should use? Also the db size would be approx 1tb after a while and will the data files will be intact without corruption?

Thanks rick for your advice. Just got some clear idea about the requirement. They are looking at 2gb/hour and approx 15-20 gb / day. Yes, I will partition the data by date and try to use vertical partitioning. The select's are occasional and will be done on the indexed column which would be the id column. I have asked them to do compression at application server and push it to db. Would you be able to suggest me any hardware for it? How fast should be the processor and how much approx memory is required for this requirement?

thanks for your help.

Thanks



Edited 1 time(s). Last edit at 10/11/2010 09:14AM by Anantha Varatharajan.

Options: ReplyQuote


Subject
Views
Written By
Posted
Partitioning help
3316
September 24, 2010 02:16AM
1782
September 25, 2010 01:09PM
1747
September 27, 2010 03:43AM
1723
September 27, 2010 07:55PM
1691
October 12, 2010 01:55AM
1672
October 12, 2010 08:03AM
1580
October 13, 2010 03:27AM
1618
October 13, 2010 06:03PM


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.