sysbench FATAL: mysql_stmt_prepare() failed

[dingyuan408]

1、准备
sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-port=30160 --mysql-db=test_db --mysql-user=usr --mysql-password=123456 --table_size=400000 --tables=8 --threads=256 --events=0 --report-interval=10 --time=600 --mysql-host=192.168.0.3 --table_size=400000 prepare
2、运行
sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-port=30160 --mysql-db=test_db --mysql-user=usr --mysql-password=123456 --table_size=400000 --tables=8 --threads=256 --events=0 --report-interval=10 --time=600 --mysql-host=192.168.0.3 --table_size=400000 run
max\u prepared\u stmt\u count个语句（当前值：16382）会报错

FATAL: mysql_stmt_prepare() failed
FATAL: MySQL error: 1461 "Can't create more than max_prepared_stmt_count statements (current value: 16382)"
FATAL: `thread_init' function failed: /usr/share/sysbench/oltp_common.lua:275: SQL API error
FATAL: mysql_stmt_prepare() failed

sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-port=30160 --mysql-db=test_db --mysql-user=usr --mysql-password=123456 --table_size=400000 --tables=8 --threads=256 --events=0 --report-interval=10 --time=600 --mysql-host=192.168.0.3 --table_size=400000 cleanup

[andyli029]

Can't create more than max_prepared_stmt_count statements (current value: 16382)

[hustjieke]

var Com_stmt_prepare not same on master/slave node.
on master:

on slave: