Results 1 to 3 of 3

Thread: Increasing MySQL Thread Stack

  1. #1
    Member
    Join Date
    Oct 2003
    Posts
    173

    Default Increasing MySQL Thread Stack

    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. #2
    Member rpmws's Avatar
    Join Date
    Aug 2001
    Location
    back woods of NC, USA
    Posts
    1,857

    Default

    just looked and noticed I see those same errors across most of my boxes and I am running 4.1 on most.
    Just keeping my "eye" on things....
    R. Paul Mathews
    RPMWS - diehard cPanel Nutcase

  3. #3
    Member
    Join Date
    Sep 2003
    Posts
    151

    Default

    We use the following on our servers:

    set-variable = thread_stack=126976

    this works fine, hope it helps.

Similar Threads

  1. Leveraging the Stack Exchange network
    By Vliegtuig in forum cPanel & WHM Discussions
    Replies: 1
    Last Post: 11-23-2010, 03:16 PM
  2. upcp error - thread.error: can't start new thread
    By JayLevine in forum cPanel & WHM Discussions
    Replies: 1
    Last Post: 12-16-2008, 09:19 AM
  3. mySQL getting backed up and increasing server load?
    By MDurai in forum cPanel & WHM Discussions
    Replies: 2
    Last Post: 03-13-2006, 12:04 PM
  4. mysql increasing server load....
    By mitul in forum cPanel & WHM Discussions
    Replies: 9
    Last Post: 04-27-2003, 11:28 PM