MySQL Forums
Forum List  »  Optimizer & Parser

Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min
Posted by: Bill Karwin
Date: June 20, 2006 12:18PM

MERGE tables may help to simplify the multi-table solution, combining multiple tables into one for purposes of querying.

http://dev.mysql.com/doc/refman/5.0/en/merge-storage-engine.html

Also the MySQL 5.1 table partitioning features might be useful. I don't know much about these features yet, but it's just a suggestion so you can go read more about it and see if it would help.

http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html

Regards,
Bill K.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min
2161
June 20, 2006 12:18PM


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.