如何解决mysql线程堆栈溢出? [英] How do I resolve a mysql Thread Stack Overrun?

问题描述

我在mysql上有一个存储过程.它在我的本地MAMP环境中可以正常运行，但该过程运行良好，但是当我将其移至linode服务器/主机时，它无法运行.我收到线程堆栈溢出"错误.我尝试从初始值64K向上提升线程堆栈.我将值更改为128K，然后更改为256K.但是问题仍然存在.

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.

我正在使用一个清晰​​的ubuntu 512MB linode服务器.我正在mysql/my.cnf文件中的linode建议配置上运行:

i am working on a lucid ubuntu 512MB linode server. I am running on linode's suggested configuration in my mysql/my.cnf file:

key_buffer = 16K
max_allowed_packet = 1M
thread_stack = 64K 
table_cache = 4
sort_buffer = 64K
net_buffer_length = 2K

任何人都可以帮忙吗?您可以建议不同的配置吗?

Can anyone help? Can you suggest different configurations?

推荐答案

我是个白痴.我将thread_stack重置为一个更大的数字，但是我没有重新启动服务器.重新启动解决了该问题.

I was an idiot. I reset the thread_stack to a higher number, but i didn't restart the server. restarting resolved the problem.

这篇关于如何解决mysql线程堆栈溢出?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！