MySQL Forums
Forum List  »  Optimizer & Parser

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

Hi.
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...
Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Why Query Cache Actived Returns Wrong Results?
2955
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.