MySQL Forums
Forum List  »  Partitioning

Re: Strategy Advice for large caching table
Posted by: Andrew A
Date: July 21, 2007 07:53AM

Hi,

Probably by partitioning by RANGE and creating partitions by day.

Then simply drop the day partitions when you do not need them anymore.

Additionally, a performance fix for your 40 minute delete is quite simple - Delete in batches.

Place a LIMIT on your delete clause (eg, LIMIT 1000) and perform the deletes over a few periods (eg, once every second or so).

This lets MySQL do less between each query, and allows other clients to keep reading from your cache table between the much lighter queries :)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Strategy Advice for large caching table
2593
July 21, 2007 07:53AM


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.