3.1

MySQL 5


If I read QueryPlanCache correctly, it keeps adding to the plan Cache
and eventually my process runs out of Memory (running with -Xmx256m)

I am suspecting that this is a case of not parameterizing queries well,
but I hope someone might have some hints here.

Thank you,
Eric Goff

Every time you execute a new query,
it gets stuck into a query plan cache.
If you issue many different queries you can count
on an OutOfMemoryException.

i.e.

select * from foo where x=2
and
select * from foo where x=3

will both get entries in the cache.

The cache seems to need an upper bound.