CockRoach 2.0 内存调整

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
报错信息：
FATAL: PQexecPrepared() failed: 7 root: memory budget exceeded: 10240 bytes requested, 134215680 currently allocated, 134217728 bytes in budget
(last message repeated 1 times)

sysbench压测cockroach高并发下报错信息.

解决办法：
./cockroach start --help

--max-sql-memory bytes          
        Maximum memory capacity available to store temporary data for SQL
        clients, including prepared queries and intermediate data rows during
        query execution. Accepts numbers interpreted as bytes, size suffixes
        (e.g. 1GB and 1GiB) or a percentage of physical memory (e.g. .25). If
        left unspecified, defaults to 128MiB.
        (default 128 MiB)
启动cockroach的时候使用 参数指定内存，默认使用的内存为128MiB。

--参考：
https://www.cockroachlabs.com/blog/memory-usage-cockroachdb/