I have a virtual server just for MySQL for a handful of apps. It's a 256 MB server. There is currently barely any data in there, but
free -m shows full memory usage:
total used free shared buffers cached Mem: 245 197 47 0 23 120 -/+ buffers/cache: 53 192 Swap: 511 2 509
This is on Ubuntu 10.04. All the configuration settings are default IIRC -- key buffer is 16, query cache is 16. (I might be missing some
So, it seems to me that with barely any data and no special settings for the buffers, I should be using well below 256. Is 256 just the lower table for what an OS + MySQL need these days?