Performance – Things to consider
In this section, we will discuss general factors related to the infrastructure that affect performance, some standard benchmarking suites, and running a benchmark for your specific needs in CockroachDB.
Infrastructure
It is important to know the ideal configuration for your infrastructure as that significantly influences the performance of CockroachDB that runs on top of it. Here are some key factors to consider in this regard:
- Central processing unit (CPU): It would be a cliché to say that the CPU plays an important role in performance. We have to ensure each node gets at least four virtual CPUs (vCPUs). You should constantly monitor the CPU usage in all nodes to quickly identify hot nodes that might be receiving more traffic than other nodes. This can make the node's CPU reach its maximum capacity, which can slow down query response times.
- Memory: Pebble key-value store, table metadata, and CockroachDB internal...
