[graphql] test cockroach cache en max-sql-memory

[coesensbert]

especially for a mainnet stack, if a server has not enough disk iops available, the processor crashes regularly with a timeout to the indexer. I have setup a spare mainnet stack with sata ssd's where I noticed this issue again. Will make some temporary changes there to increase the indexer db (cockroach) memory usage since the default cache is only 128MiB.

https://www.cockroachlabs.com/docs/stable/recommended-production-settings#cache-and-sql-memory-size

--cache=.45
--max-sql-memory=.45

[coesensbert]

applied to test to

• prod-02
• mainnet grid snapshot server

[coesensbert]

nice! https://mon.grid.tf/d/rYdddlPWk/node-exporter-full?orgId=1&var-DS_PROMETHEUS=default&var-job=node_exporter&var-node=prod-02:9100&var-diskdevices=%5Ba-z%5D%2B%7Cnvme%5B0-9%5D%2Bn%5B0-9%5D%2B&from=now-24h&to=now&refresh=30s

more mem usage: less iops:

[coesensbert]

No issues found so far. On the mainnet snapshot server noticed the processor restarting less, so that's a good sign. This srv has too few iops for a mainnet stack, so the processor issue was not going away but since it was very present there it was a good place to test. Will apply the change to devnet and continue testing there before going to the other nets.

[coesensbert]

no issues detected or reported

[coesensbert]

seems good, will continue with qa, test and mainnet