MYSQL教程Mysql Error Code : 1436 Thread stack overrun

《MYSQL教程Mysql Error Code : 1436 Thread stack overrun》要点：
本文介绍了MYSQL教程Mysql Error Code : 1436 Thread stack overrun，希望对您有用。如果有疑问，可以联系我们。

MYSQL应用ERRNO: 256 
TEXT: SQLSTATE[HY000]: General error: 1436 Thread stack overrun: 4904 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack. 

MYSQL应用According to the MySQL manual “The default (192KB) is large enough for normal operation. If the thread stack size is too small, it limits the complexity of the SQL statements that the server can handle, the recursion depth of stored procedures, and other memory-consuming actions” .

MYSQL应用To resolve this issue you need to change the default value of parameter 'thread_stack' in /etc/my.cnf  in your MySQL configuration file. I use the XAMPP for php/mysql development. 

MYSQL应用

MYSQL应用Once you set this value you need to restart MySQL as this value cannot be set dynamically.

MYSQL应用you maybe also encounter with the message when you try to modify the my.cnf

MYSQL应用"Cannot open file for writing: Permission denied"

MYSQL应用We will try to use the 'chmod' instruction to change permission as usually. I seldom take the concrete permission into consideration, so I use always use the 'chmod 777'. but it resulted in another errors when I use the phpmyadmin, another tools included in XAMPP, after running 'chmod 777'.

MYSQL应用

MYSQL应用After googling it, I get this file (my.cnf) permissions has to be 600. I change its permission and it works well now.

MYSQL应用bug info

MYSQL应用报错信息:
java.sql.SQLException: Thread stack overrun: 5456 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.

MYSQL应用官方相应信息:

MYSQL应用The default (192KB) is large enough for normal operation. If the thread stack size is too small, it limits the complexity of the SQL statements that the server can handle, the recursion depth of stored procedures, and other memory-consuming actions

MYSQL应用可以使用

MYSQL应用show variables where `variable_name` = 'thread_stack';

MYSQL应用查询当前数据库的默认线程栈的大小,一般情况下都能正常使用,但是当查询语句或者存储过程复杂时会报Thread stack overrun错误,此时只要修改默认配置就可以.

MYSQL应用解决

MYSQL应用windows: 修改mysql安装目录下的my-small.ini或者my.ini设置为256k,或者更大,然后重启服务

MYSQL应用[mysqld]
thread_stack = 256k
linux: 同样要修改配置文件,但是!!!,不是安装目录下的配置文件,是/etc/my.cnf,只有这个文件才能生效,然后重启服务service mysql restart

MYSQL应用[mysqld]
thread_stack = 256k

MYSQL应用其实针对32位系统,32G内存,一般设置为512K即可,据国外网站看到的,如果是64位的系统可以适当增加,其实够用就好了,没必须刚开始设置的就很大.

转载请注明本页网址：
http://www.vephp.com/jiaocheng/1017.html