MySQL Forums
Forum List  »  Partitioning

Re: Partitioning help
Posted by: Anantha Varatharajan
Date: September 27, 2010 03:43AM

Thanks Rick for your response. We have blade server with Fiber channel san attached to it. They are looking at approximately 1000 inserts/hour with HTML data being zipped and inserted. The message is queued to a JMS queue and being inserted to the db (sorry I don't understand that very well). Think it can be batched up. The requirement is that the inserts should take less than 0.05 seconds. The data is more of a logging data where it is required to be stored for a while(2 weeks for now) and then deleted. I have not created a database or tables yet so don't have the table structure. But the table needs to have a id column which is unique and inserted from the application where I need to have a index on it. There is one more column "type" which is used to identify the type of requests if it's one of A , F, C. So I want to have 3 tables partitioned by day and type so that I can drop the old partitions when I don't need it. Disk space is not a constraint. The data is not very sensitive so backups are not required. writes are more important factor of the db and they should be able to read the data as well without blocking writes.
Could you suggest me the best way for partitioning the data? Also I would like to know if myIsam would be reliable and can store that quantity of data?

Please let me know if something is not clear

thank you very much..

Options: ReplyQuote

Written By
September 24, 2010 02:16AM
September 25, 2010 01:09PM
Re: Partitioning help
September 27, 2010 03:43AM
September 27, 2010 07:55PM
October 12, 2010 01:55AM
October 12, 2010 08:03AM
October 13, 2010 03:27AM
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.