Top "Query-cache" questions

Query Cache is the cache, that stores the database queries and their results.

Why does an insert query occasionally take so long to complete?

This is a pretty simple problem. Inserting data into the table normally works fine, except for a few times where …

sql mysql performance query-cache
How to flush db query cache in yii2?

How to handle it when some changes happen in specific table records ? public static function getAirportWithCache($iata_code){ $result = Airports::…

yii2 query-cache
View mysql query cache contents

I have a large database application that uses mysqls query cache ability. I'd like to inspect the contents of the …

mysql query-optimization query-cache
What does the MySQL Query cache Hitrate % value respesent?

Using MySQL Workbench I am looking at the Admin view for two servers I run. Both servers have a similar …

mysql mysql-management query-cache
MySQL flush query cache

I have a slow database query that runs 18 seconds for the first run and 4 seconds as any subsequent run. I …

mysql performance query-cache