How is MySQL using RAM

MySQL & MariaDB Other MySQL® Questions
1

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?

2

To answer your questions I’d like to ask mine :wink:

  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?

3
  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?

4

Usually you reserve half of the process addressspace for OS usage.
That’s why you can only use 2GB.

5
[B]sterin wrote on Tue, 25 September 2007 22:35[/B]
Usually you reserve half of the process addressspace for OS usage. That's why you can only use 2GB.
From my post two steps up.

If you want to use your servers potential you should run a 64bit OS and 64bit MySQL.