Bug #21110 limit of max_sp_recursion_depth
Submitted: 18 Jul 2006 10:46 Modified: 18 Jul 2006 16:46
Reporter: Nikolay Shestakov Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Stored Routines Severity:S4 (Feature request)
Version:5.0 OS:Any (All)
Assigned to: CPU Architecture:Any

[18 Jul 2006 10:46] Nikolay Shestakov
please, increase max_sp_recursion_depth up to 65535. Now max value is 255.

How to repeat:
set global max_sp_recursion_depth = 1024;

select @@max_sp_recursion_depth;
--> return 255
[18 Jul 2006 16:46] Valeriy Kravchuk
Thank you for a reasonable feature request.
[7 May 2008 14:37] Helmut Neubauer
Is there a plan to increase the maximum possible value?
[9 Aug 2010 13:12] Markus Schmid
No change in here?
Please increase that value, 255 is not enough for complex routines.
[28 Apr 2011 22:04] Anthony Galano
Any progress on this? I can't imagine it would be that hard. 255 is simply too small for complex routines or large datasets. For instance we use recursion to calculate and store nested set organizational tree but are stuck at 255 nodes.  Any modern hardware should have no problems with 65k+ as recommended.
[6 Apr 2012 13:51] Jamie Solomons
I completely agree, please can you look to increase the maximum possible value?
[6 Dec 2018 11:21] Harikrishna Guggilla
Please increase it to 65k, 255 is not enough