2007
MariaDBWARNINGCriticalPerformanceMEDIUM confidence
Query cache cleanup warning
Production Risk
Low — informational warning only.
What this means
The query cache encountered an issue during cleanup, typically when flushing invalidated cache entries. This is informational and does not affect query correctness.
Why it happens
- 1High write rate causing frequent query cache invalidations.
- 2Large query cache size slowing down cache flush operations.
How to reproduce
trigger — this will error
trigger — this will error
-- Observed in MySQL error log during heavy write workloads with query_cache_type ON
expected output
Warning 2007: Query cache cleanup.
Fix
Disable the query cache if it causes performance problems
Disable the query cache if it causes performance problems
SET GLOBAL query_cache_type = OFF; SET GLOBAL query_cache_size = 0;
Why this works
The query cache is deprecated in MySQL 5.7 and removed in 8.0.
What not to do
✕
Version notes
Sources
Official documentation ↗
MySQL 5.7 — 2007 ER_WARN_QS_CLEANUP
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev