Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

We recommend a buffer of at least 1 GB. If you have more than eight gateways, 1.5 GB may also be necessary.

You can also take a step-by-step approach:

...

https://mariadb.com/kb/en/innodb-buffer-pool/

Info

If you have a lot of gateways with a lot of APIs, the following settings are a good place to start.

  • --innodb_buffer_pool_size=4G

  • --query_cache_size=2G

  • --max_allowed_packet=536870912