WL#13342: Increase max value for max_prepared_stmt_count
Affects: Server-8.0
—
Status: Complete
Increase max value for max_prepared_stmt_count from 1 to 4 million (no change to the default value of 16K) https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_prepared_stmt_count Motivation: We want to be able to test 40K connections using Sysbench with prepared statements and up to 8 tables. Sysbench with prepared statements and 8 tables gives 11 queries x 8 tables = 88 prepared statements per connection. Then 88 x 40K connections = 3520K prepared statements Memory usage: Estimated to 2 KB per prepared statement, so estimated max equals to 4 million x 2KB = 8GB
Copyright (c) 2000, 2024, Oracle Corporation and/or its affiliates. All rights reserved.