>says 18m?
By looking at the overall memory usage. Switch the service off and 400M reappears. Turn it on and 400mb is no longer available, with no sign of who is doing it.
>What table handlers are you using? What's your my.cnf look like?
myisam exclusively. I went to go copy my.cnf and discovered the problem...
There was no my.cnf.
Apparently (the old my.cnf file is still present as a .bak) when I upgraded to 4.0.16 from an early alpha the installer goofed. No revised my.cnf was created and it seems if no my.cnf then mySQL defaults to eating resources equivalent to the my-huge.cnf file. The key_buffer setting of 384m was the main culprit.
So I built a new one based on my-medium.cnf and all is back to normal.
So... What mySQL eats for its caches is not registered by Win2k's Task Manager. Try it by pumping up your key_buffer value and you should see free memory loss with no sign of where its going. Interesting.
Thanks very much for helping out,
--Matt Robertson--
MSB Designs, Inc.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
