Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2005
    Location
    Harrisburg, PA
    Posts
    776

    MySQL - excessive memory usage?

    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.

  2. #2
    Join Date
    Apr 2005
    Location
    Cochin
    Posts
    2,446
    whats the VPS configuration. Seems like you mysql is not optimized for the VPS resources.
    Sam
    Supportlobby.com - Expertise in Windows/Linux server support, IaaS and PaaS Management
    Spiralbean.com - Custom Software Development
    Email: exec @ activelobby.net | Skype: unni_active

  3. #3
    Join Date
    Nov 2005
    Location
    Harrisburg, PA
    Posts
    776
    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.

  4. #4
    Join Date
    Aug 2002
    Location
    Manchester, UK
    Posts
    367
    If you're concerned about MySQL memory usage I'd suggest searching for information on tweaking MySQL via /etc/my.cnf. If your VPS is managed, your provider should be able to do this for you.
    Andrew Cranson, Director of Operations
    Layershift Fully Managed Cloud Hosting :: WizzVPS Cheap Unmanaged VPS :: UK, USA, Singapore
    Jelastic :: Next generation PaaS - UK Java & PHP Hosting
    True 24x7 Technical Support - peace of mind around the clock!

  5. #5
    Join Date
    Dec 2005
    Location
    Lawrenceville GA
    Posts
    54
    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.
    Ralph Smith ~ New Business Hosting Inc.
    http://www.newbusinesshosting.com
    24x7 Support cPanel, Fast Setup

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •