I believe you can use…
RESET QUERY CACHE;
…if the user you’re running as has reload rights. Alternatively, you can defragment the query cache via…
FLUSH QUERY CACHE;
See the Query Cache Status and Maintenance section of the MySQL manual for more information.
Related Contents:
- How To have Dynamic SQL in MySQL Stored Procedure
- MySQL: Insert record if not exists in table [duplicate]
- How to do the Recursive SELECT query in MySQL?
- What is the ideal data type to use when storing latitude / longitude in a MySQL database?
- How can I search (case-insensitive) in a column using LIKE wildcard?
- Is there a REAL performance difference between INT and VARCHAR primary keys?
- Get records with highest/smallest per group
- Ordering by specific field value first
- SQL Performance UNION vs OR
- MySQL “Group By” and “Order By”
- Mysql order by specific ID values
- Access denied for user ‘root’@’localhost’ while attempting to grant privileges. How do I grant privileges?
- MySQL: Fastest way to count number of rows
- Equivalent of Oracle’s RowID in MySQL
- ERROR 1130 (HY000): Host ” is not allowed to connect to this MySQL server [duplicate]
- MySQL user DB does not have password columns – Installing MySQL on OSX
- Convert MySQL schema to Github Wiki?
- How to convert all tables from MyISAM into InnoDB?
- Setting up foreign keys in phpMyAdmin?
- MySQL maximum memory usage
- Get the latest date from grouped MySQL data
- How can I get rid of these comments in a MySQL dump?
- Table is specified twice, both as a target for ‘UPDATE’ and as a separate source for data in mysql
- SQL Query to show nearest date?
- How to create relationships in MySQL
- How to get the next auto-increment id in mysql
- Add Auto-Increment ID to existing table?
- Return the nth record from MySQL query
- Order by COUNT per value
- Why does MySQL autoincrement increase on failed inserts?
- What is the MySQL query equivalent of PHP strip_tags?
- Error renaming a column in MySQL
- How to auto generate migrations with Sequelize CLI from Sequelize models?
- Resetting ROOT password in MySQL 5.6
- SQL Group By with an Order By
- How to select only date from a DATETIME field in MySQL?
- How to schedule a stored procedure in MySQL
- Sorting by date & time in descending order?
- Making changes to multiple records based on change of single record with SQL
- MySQL floating point comparison issues
- How to get the count of each distinct value in a column? [duplicate]
- MySQL INSERT INTO … VALUES and SELECT
- MySQL InnoDB: autoincrement non-primary key
- No Entity Framework provider found for ‘MySql.Data.MySqlClient’ ADO.NET provider
- Get difference in years between two dates in MySQL as an integer
- Returning query results in predefined order
- How to force case sensitive table names?
- How can I implement single table inheritance using Laravel’s Eloquent?
- Referring to a select aggregate column alias in the having clause in Postgres
- How do I make a MySQL database run completely in memory?