MySQL Forums
Forum List  »  Optimizer & Parser

Why Query Cache Actived Returns Wrong Results?
Posted by: Daniel Estrada
Date: September 22, 2012 08:57PM

I need to do some queries to tables with records very big. So this takes a lot of time, so I active cache, to make things faster, but sometimes, I get wrong results, because sometimes the result is 0. If I do the same query, with cache disabled, I get the right results. Do I need to configure another parameter? I configure query_cache_size=1G. My table is MyISAM...

Options: ReplyQuote

Written By
Why Query Cache Actived Returns Wrong Results?
September 22, 2012 08:57PM

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.