if i set a key cache size of 100% the way i understand how that works is:

- the cache is not write through, but read through
- a key gets added to the cache on the first read if not already available
- the size of the cache will always increase for ever item read.  so if you have 100mil items your key cache will grow to 100mil

Here are my questions:

if that is the case then what happens if you only have enough mem to store 10mil items in your key cache? 
do you lose the other 90% how is it determined what is removed?
will the server keep adding til it gets OOM?
if you add a row cache as well how does that affect your percentage? 
if there a priority between the cache? or are they independant so both will try to be satisfied which would result in an OOM?

thanx,
artie

--
http://yeslinux.org
http://yestech.org