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?