为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:v4.0.0
- 【问题描述】:sysbench 压测 tidb 提示
$ sysbench --config-file=config oltp_insert --tables=32 --table-size=10000000 run
sysbench 1.0.17 (using system LuaJIT 2.0.4)
Running the test with following options:
Number of threads: 3072
Report intermediate results every 10 second(s)
Initializing random number generator from current time
Initializing worker threads…
Threads started!
[ 10s ] thds: 3072 tps: 29430.65 qps: 29430.65 (r/w/o: 0.00/29430.65/0.00) lat (ms,95%): 223.34 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 3072 tps: 25515.20 qps: 25515.30 (r/w/o: 0.00/25515.30/0.00) lat (ms,95%): 314.45 err/s: 0.00 reconn/s: 0.00
FATAL: `thread_run’ function failed: not enough memory
Error in my_thread_global_end(): 1 threads didn’t exit
Mon Jul 6 11:10:38 CST 2020
sysbench config 线程数 3072
threads=3072
初步判定为 sysbench 使用 线程数过高 来压测tidb 导致的问题, 需要对 tidb 或者 sysbench 所在服务器参数进行调优