(I have checked similar questions, none of them cover my situation)
I'm trying to increase MySQL 5.7 memory usage on my Ubuntu 16.04. Before my changes
mysqld was using about 8% of RAM out of 8GB available which means the InnoDB buffer pool was probably set to 512MB.
innodb_buffer_pool_size to 4G, I restart
mysqld, then I check the
@@innodb_buffer_pool_size variable: it shows
4294967296 which is correct.
top is telling me that the memory usage is still at 8%! I have some pretty large tables with millions of records, I run heavy queries but no matter what,
mysqld never seems to go over 8%. And yes, all my tables use InnoDB.
I tried to also play with
innodb_buffer_pool_chunk_size but again, the changes are reflected in the @@ variables but nothing makes
mysqld go over 8%, so I reverted these two variables to their defaults.
Every article or SO answer on the subject says that changing
innodb_buffer_pool_size and restarting MySQL should be sufficient. What am I doing wrong?