On my mac, after a fresh restart with zero connections, MySQL is currently using 40MB of memory, 188MB of virtual memory (on-disk database paged in?), and has 16 threads.
Since there's only ever one person accessing the server (me), and I don't hit it very often throughout the day, how can I configure MySQL to consume less memory when it's idle?
I don't mind it consuming as many resources as it needs to get queries done while they're executing, but would like to lower the footprint in between development sessions. Because of how the websites I work on function, it will only ever run one query at a time, maybe two simultaneous queries very occasionally.
I'm running MySQL on Mac OS X Server 10.7, using Oracle's official download, with no configuration changes.
40MB is usually fine, but lately I've been doing some non-MySQL development work that really does need every inch of memory my system has, and I'd rather not start/stop MySQL a few times each day.