managing table size?

[xinie]

Hi people,
I have big multiple tables in our production DB i.e. 1M+ records in size. As the data in these tables ages, it becomes less relevant to the system, by periodically deleting old records we may achieve manageable DB size.
Can someone here suggest a best way to do this, plz?
Thank you. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Terrell]

Try to partition the data by making the value of "time" part of the table name and dropping the tables as they become old. InnoDB is slow at deleting records if there are many secondary indexes. For inserting to secondary indexes, the insert buffer makes access more sequential. There is no such buffering for deletes. However, DROP TABLE is a very fast operation. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --