MySQL Forums
Forum List  »  Partitioning

Re: truncate partition not happening
Posted by: Mattias Jonsson
Date: January 13, 2012 10:13AM

Rick James Wrote:
> Ouch! Could there be other ALTER statements that
> fail to notify the QC?

I have not found any other ALTER statement missing invalidating the QC.

> A side question...
> The QC purges all entries for a "table" upon any
> write -- but in the case of PARTITION, is "table"
> the entire table, or just the one sub-table
> (partition) that was modified?

The QC works on table level only. So any write to the table should invalidate the whole table (all partitions).

Also bug#53775 is known with QC + partitioning. And the best solution would be to change the API for the query cache which would also allow support for 'partition pruning aware' QC.

Options: ReplyQuote

Written By
January 09, 2012 08:06AM
January 13, 2012 09:58AM
Re: truncate partition not happening
January 13, 2012 10:13AM

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.