I need to increase max_prepared_stmt_count
, and I can do that easily by running
set global max_prepared_stmt_count=50000;
The problem, though, is that number gets reset to the default everytime after a reboot. I've tried adding in lines like
max_prepared_stmt_count=50000;
into various config files, but they spit out the same error:
mysql: [ERROR] unknown variable 'max_prepared_stmt_count=50000'
Anybody know what I'm doing wrong?
[mysqld]
section. And don't add the semicolon. – wurtel Nov 6 '19 at 7:52