MySQL table caching returns stale data -


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