I have query caching disabled (this is disabled by default on my installation) but getting older data in my application is. For example, I will do my SELECT *
on the review
table, enter a new row and then another SELECT *
, but the new review (Although if I browse in phpMyAdmin
in the table, it will be) I disabled the table caching ( table_cache = 0
) and the items Began to fix, in which all new reviews were shown on the second SELECT *
.
MySQL documentation says that
the query cache does not return stale data when the tables are modified, any relevant entries in the query cache are flushed .
Is this table not even right for cache? Is there a way to use MySQL table caching, but once it is modified in the cached table it can be forced to flush the cache?
I really did not find much
Comments
Post a Comment