a9s MySQL Resources Considerations

This document describes concerns and limitations to be considered when allocating resources for your a9s MySQL plans.

Reserved Memory

The relevant buffer configuration configured by a9s MySQL is innodb_buffer_pool_size, which by default, is 50% of total_memory - 1GB reserved. a9s MySQL reserves 1GB for side processes, and it is configured to use 50% of the remaining memory.

The remaining memory is shared with other small buffers, side processes, and the OS. It is important to notice that the number of open connections influences on the usage of the remaining memory. Currently, max_connections is configured as 1500, but to instances, this might be too much, and the number of open connection will directly affect the performance of your node.