content_image/713096.jpg content_image/713097.jpg content_image/713098.jpg
<img src='content_image/713096.jpg'>

The number of bytes to use when sorting data values. The server uses only the first max_sort_length bytes of each value and ignores the rest. Consequently, values that differ only after the first max_sort_length  bytes compare as equal for GROUP BY , ORDER BY , and DISTINCT  operations. 

Increasing the value of max_sort_length  may require increasing the value of sort_buffer_size  as well. For details, see Section 8.2.1.16, “ORDER BY Optimization” 

• max_sp_recursion_depth 

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

The number of times that any given stored procedure may be called recursively. The default value for this option is 0, which completely disables recursion in stored procedures. The maximum value is 255. 

Stored procedure recursion increases the demand on thread stack space. If you increase the value of max_sp_recursion_depth , it may be necessary to increase thread stack size by increasing the value of thread_stack  at server startup. 

• max_user_connections 

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

