Can anyone please provide some tuning advice?
I have a single node CRDB server coupled with Nakama as a game server. Over a period of several weeks, the performance degraded until it impacted the game. I did a backup and recreated the database after which performance was back to it’s best but it is now degrading again.
The symptoms are:
- increased use of disk space although the actual data stored is very much lower
- Dramatic increase in database reads
- Increase in CPU load
gc.ttlseconds=3600 before restarting the server when I recreated the database but it’s unclear if this had a major beneficial effect.
I would appreciate any useful pointers. Thanks!