I tested performance of one-node cockroachdb using sysbench.
The test case of sysbench is oltp-insert.lua.
The result is:
- TPS in sysbench: 4000
- %CPU of cockroach: 300%
My test machine has 32 CPUs and 62G memory.
Cockroachdb version is 2.0.0.
In the same machine, I also tested mysql-5.7 using the same sysbench
test case, and the result is:
- TPS in sysbench: 45000
- %CPU of mysqld: 2000%
So, my questions are
- how to improve one-node cockroachdb performance, to eat up all the CPUS?
- is there any article about performance comparision of cockroachdb and mysql?