content_image/683366.jpg content_image/683367.jpg content_image/683368.jpg
<img src='content_image/683366.jpg'>

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. 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. Setting the value to 0 disables prepared statements. 

## • max_seeks_for_key 

<img src='content_image/683367.jpg'>

Limit the assumed maximum number of seeks when looking up rows based on a key. The MySQL optimizer assumes that no more than this number of key seeks are required when searching for matching rows in a table by scanning an index, regardless of the actual cardinality of the index (see Section 13.7.7.22, “SHOW INDEX Statement” ). By setting this to a low value (say, 100), you can force MySQL to prefer indexes instead of table scans. 

## • max_sort_length 

<img src='content_image/683368.jpg'>

