Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

How is MySQL using RAM

untenableuntenable EntrantCurrent User Role Beginner
My MySQL memory usage isn't high enough ). I've a 10GB database on a 8GB-RAM DB Server. MySQL is only consuming 2GB of RAM.

How do I figure out what buffers MySQL is using the 2GB of RAM for?

That'll give me some insight as to what buffers are being maxed out and need more memory.

Is there any other solution to this problem? Shouldn't MySQL cache more in RAM so it has to hit the DB less often?

Comments

  • scoundrelscoundrel Contributor Inactive User Role Beginner
    To answer your questions I'd like to ask mine ;)

    1) What storage engine do you use for your tables: innodb/myisam?

    2) What CPU do you use on your server: 32-bit/64 bit?

    3) What OS do you use: name, version, 32/64 bit?
  • untenableuntenable Entrant Current User Role Beginner
    1. Currently Myisam but I'm working on converting to innodb
    2. OS & CPU are 64 bit
    3. OS is centOS..not sure where the OS version info is ).

    Is there some tool that dumps the size of/info about various mysql buffers/caches?
  • sterinsterin Mentor Inactive User Role Contributor
    Usually you reserve half of the process addressspace for OS usage.
    That's why you can only use 2GB.
  • sterinsterin Mentor Inactive User Role Contributor
    <table border="0" align="center" width="90%" cellpadding="3" cellspacing="1"><tr><td class="SmallText">sterin wrote on Tue, 25 September 2007 22:35</td></tr><tr><td class="quote">
    Usually you reserve half of the process addressspace for OS usage.
    That's why you can only use 2GB.


    </td></tr></table>
    From my post two steps up.

    If you want to use your servers potential you should run a 64bit OS and 64bit MySQL.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.