During the performance test, we found that the database resource consumption is relatively high. Are there any related configurations that can be optimized.
- The entire environment is deployed using Docker.
- CPU: 8-core 16 threads
- Memory: 16g
- 2000 gateways, with one node under each gateway，each node pushes data every 10 seconds.
- CPU:90%(The main reason is that the database occupies too much CPU resources)
I think it’s because every time a node pushes data or the gateway has a heartbeat, it refreshes the ‘gateway’ and ‘device’ tables in the NS/AS database.If so, do you consider placing this frequently modified data in Redis for processing.Or what deployment suggestions are available when considering 1000k nodes.
If cluster deployment is considered, are there any relevant configuration examples