Increase InnoDB buffer pool size
Solution 1:
Make sure those lines are within the [mysqld]
section i.e. after [mysqld]
but before any other [section]
such as [mysqldump]
.
Solution 2:
Check your MySQL error log for information - most likely located in /var/lib/mysql
- also, is this a 32-bit system with the bigmem kernel? If so, you can't address more than 2GB for MySQL.
Also - you'll want to confirm from MySQL itself about the buffer pool size - 16MB sounds a bit off, considering the default is 128M. You can confirm this by typing 'SHOW VARIABLES LIKE 'innodb_buffer_pool_size' into a MySQL session for that server. Result is in bytes.
Solution 3:
In my case the problem was innodb_buffer_pool_instances
.
Since I was reducing innodb_buffer_pool_size
, it became less than one 1GB per instance, so it ended up rounding it.
When I also reduced the instances, it finally changed the pool size!