Skip to main content
added 5 characters in body
Source Link
Rick James
  • 79.4k
  • 5
  • 51
  • 117

innodb_buffer_pool_size=9G

That accounts for 9GB of usage. That setting does not need to be much bigger than the total amount of data and indexes you have, and should not be much more than about 70% of available RAM.

If the memory usage is bothering you, change that to, say, 100M until you have a lot more data than your current 13M.

(There is a lot of junk inat the start of your my.cnf; fortunately, it is overridden by later values.)

innodb_buffer_pool_size=9G

That accounts for 9GB of usage. That setting does not need to be much bigger than the total amount of data and indexes you have, and should not be much more than about 70% of available RAM.

If the memory usage is bothering, change that to, say, 100M until you have a lot more data than your current 13M.

(There is a lot of junk in the start of your my.cnf; fortunately it is overridden by later values.)

innodb_buffer_pool_size=9G

That accounts for 9GB of usage. That setting does not need to be much bigger than the total amount of data and indexes you have, and should not be much more than about 70% of available RAM.

If the memory usage is bothering you, change that to, say, 100M until you have a lot more data than your current 13M.

(There is a lot of junk at the start of your my.cnf; fortunately, it is overridden by later values.)

Source Link
Rick James
  • 79.4k
  • 5
  • 51
  • 117

innodb_buffer_pool_size=9G

That accounts for 9GB of usage. That setting does not need to be much bigger than the total amount of data and indexes you have, and should not be much more than about 70% of available RAM.

If the memory usage is bothering, change that to, say, 100M until you have a lot more data than your current 13M.

(There is a lot of junk in the start of your my.cnf; fortunately it is overridden by later values.)