Troubleshooting of high memory usage and solutions:
Check the memory use in the Memory label on the Dashboard.
Solution:
Control the number of concurrent connections. Calculate the number of clients in your application and the size of the connection pool configured for each client when connecting to the database. The total number of connections should not exceed 80% of the maximum number of connections supported by the current instance. Too many connections can lead to increased overhead in memory and multi-threaded contexts, affecting the request processing latency.
We recommend that you configure no more than 200 connection pools.
Reduce memory overhead per request, for example, by creating indexes to reduce scanning on the collection, memory sorting, and so on.
If the memory usage continues to increase when the number of connections is appropriate, we recommend that you upgrade the memory configuration to avoid memory overflow and large cache clearing, which may cause degraded system performance.