If both the loading of resources from a gateway and the AAGM interface are very slow, the problem could be that the Gateway Manager's database buffer is too low.

We recommend a buffer of at least 1 GB.

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

1. Increase the buffer

   • innodb_buffer_pool_size is a read_only variable. You have to shut down the database first.

   • SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
   • --innodb_buffer_pool_size=1G

     • See all recommended settings here: Installation | Start the Containers Using Docker Compose

2. Restart the database

3. Perform some operations in the Gateway Manager

   • Something with a lot of database access, for example: Reloading Resources or Discover APIs

4. Check the buffer utilisation

   1. SELECT FLOOR((SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE variable_name = 'Innodb_buffer_pool_bytes_data') * 100 / (SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name = 'innodb_buffer_pool_size')) AS BufferPoolUsageInPercent

   2. Start again at step 1 if the utilisation of the buffer is higher than 80 percent.

InnoDB Buffer Pool