I'm checking into a buffer pool issue on a MySql database. According to the query to get database size shown here, the total database size is about 11GB. Unfortunately I know I have much less RAM than that; only about 4.5GB total for this VM. So I check InnoDB buffer pool usage, expecting to see it almost at capacity. Instead I see the opposite:
show engine innodb status \G;
... Buffer pool size 163839 Free buffers 132864 ...
It seems the buffer pool is hardly touched. And, yes, these are all InnoDB tables:
SELECT Engine, COUNT(*) "Count" FROM Information_Schema.Tables WHERE table_schema = 'My_Database' GROUP BY Engine;
Engine Count ----- ----- InnoDB 169
What could be going on here?