I am having an impossible time attempting to increase the thread_stack that mysql starts with.
I have followed examples of altering the /etc/my.cnf and adding in :
and I have tried: set variable = thread_stack=192K
I have two dual athalon servers. One gives the error :
060201 13:14:06 Warning: Asked for 196608 thread stack, but got 126976
/usr/sbin/mysqld: ready for connections.
Everytime I restart mysql. Mysql works but i get this in the err file.
The other server does not give me this message and both servers have the same hardware and almost identical my.cnf files. Show Variables; in mysql shows that both servers request 126976 as a thread_stack..
so why does one throw an error and the other doesent?
do i need to alter the one that throws the error to request a 192 stack?
I am using Version: '4.0.25-standard