title: How do I resolve a mysql Thread Stack Overrun?
body: <p>I have a stored procedure on mysql.  It worked on my local MAMP environment, the procedure worked well, but when I moved it to a linode server/host it does not run.  I'm getting a "Thread Stack Overrun" error.  I have tried upping the thread stack up from an initial value 64K.  I changed the value to 128K then to 256K.  but the problem still occurs.  </p>
  
  <p>i am working on a lucid ubuntu 512MB linode server.  I am running on linode's suggested configuration in my mysql/my.cnf file:</p>
  
  <pre><code>key_buffer = 16K
  max_allowed_packet = 1M
  thread_stack = 64K 
  table_cache = 4
  sort_buffer = 64K
  net_buffer_length = 2K
  </code></pre>
  
  <p>Can anyone help?  Can you suggest different configurations?</p>