CockRoach 2.0 内存调整

报错信息：
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/

最后

以上就是鲜艳石头为你收集整理的CockRoach 2.0 内存调整的全部内容，希望文章能够帮你解决CockRoach 2.0 内存调整所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。