The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Increasing MySQL Thread Stack

Discussion in 'General Discussion' started by WestBend, Feb 1, 2006.

  1. WestBend

    WestBend Well-Known Member

    Joined:
    Oct 12, 2003
    Messages:
    173
    Likes Received:
    0
    Trophy Points:
    16
    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 :
    thread_stack=192K

    and I have tried: set variable = thread_stack=192K

    Neither works..
    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
     
  2. rpmws

    rpmws Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    1,824
    Likes Received:
    5
    Trophy Points:
    38
    Location:
    back woods of NC, USA
    just looked and noticed I see those same errors across most of my boxes and I am running 4.1 on most.
     
  3. 10101

    10101 Well-Known Member

    Joined:
    Sep 4, 2003
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    16
    We use the following on our servers:

    set-variable = thread_stack=126976

    this works fine, hope it helps.
     
Loading...

Share This Page