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 :)
Subject
Views
Written By
Posted
3883
July 16, 2007 03:45AM
Re: Strategy Advice for large caching table
2728
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.