The configuration community:
Search the Site:

max_prepared_stmt_count

Information

This variable limits the total number of prepared statements in the server. It can be used in environments where there is the potential for denial-of-service attacks based on running the server out of memory by preparing huge numbers of statements. The default value is 16382. The allowable range of values is from 0 to 1 million. If the value is set lower than the current number of prepared statements existing statements are not affected and can be used but no new statements can be prepared until the current number drops below the limit. This variable was added in MySQL 4.1.19.

Syntax

Example

728x90