Bug #74986 please make thread_stack a dynamic variable
Submitted: 24 Nov 2014 17:04
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S4 (Feature request)
Version:5.7.5 OS:Any
Assigned to: CPU Architecture:Any
Tags: thread_stack

[24 Nov 2014 17:04] Shane Bester 
Description:
Would be nice to have this dynamic to affect new thread creations.

mysql> select version(),@@global.thread_stack;
+-----------+-----------------------+
| version() | @@global.thread_stack |
+-----------+-----------------------+
| 5.7.6-m16 |                262144 |
+-----------+-----------------------+
1 row in set (0.00 sec)

mysql> set global thread_stack=1024*512;
ERROR 1238 (HY000): Variable 'thread_stack' is a read only variable

How to repeat:
set global thread_stack=1024*512;
select version(),@@global.thread_stack;
[25 Nov 2014 9:25] Simon Mudd 
Yes, I agree. Having to restart mysqld to fix this would be rather disruptive on a production server.
[25 Mar 2015 9:30] MySQL Verification Team 
http://bugs.mysql.com/bug.php?id=76479 is a duplicate