I'm not sure if this is going into the right forum or not, but since it can be relevant to anyone working in a limited-resources environment like a VPS, I figured this would be my best shot.
What's a typical memory footprint for MySQL? Upon starting mysqld on a fresh installation, I see my RAM consumption skyrocket by about 130 - 160mb. Stopping mysqld returns memory usage to around 30mb. We're talking about a clean OS install here as well (either Gentoo or CentOS 5, fully updated) running only webmin. Apache2, sshd, vsftpd, everything else stopped.
Is it just me? 160mb seems excessive for an empty database server.
What specific information are you looking for? I'm on a quad-core Xeon 5310 under HyperVM. 384 / 768mb RAM. At this very moment I'm running Gentoo built for i686, fully updated. However, I see the exact same behavior under CentOS 5.
More often then note though youll see it's not the mysql itself loading up but the queries passed to it. Theres some real garbage scripts out there that will load mysql up. Even a perfectly tuned mysql server is at the mercy of poorly thought out queries and table designs.