MySQL Forums
Forum List  »  Optimizer & Parser

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: Ijaz Rashid
Date: June 20, 2006 07:06AM

Need little SQL help please!

How to implement Roll-over in one table of database.
I'm having a table, XYZ containing 10million records. I want if record count exceed 10millions, then 30 lack

records from top of table should be deleted very efficiently. XYZ contains 10milloin records and still 1lack

records are inserted in it every second. If i use delete statment like

delete from group_1sec_1 ORDER BY time limit 3000000;

it takes many 10+ minutes to delete records
If i use multiple tables, then TRUNCATE table works.
But i want to avoid multiple tables


Is there any way to physically / logically divide one table into two tables/clusters/diskSpaces...
In this way we can truncate one tables/clusters/diskSpaces... which takes 0.5 sec for 10million records.

Please send me some reference article as well. Thank you for your help.

Ijaz R

Options: ReplyQuote


Subject
Views
Written By
Posted
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
4963
June 20, 2006 07:06AM


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.