Mysql Error Code : 1436 Thread stack overrun

来源:http://www.prospettivedarte.com 作者:计算机教程 人气:51 发布时间:2020-03-24
摘要:windows:修改mysql安装目录下的my-small.ini或者my.ini设置为256k,或者更大,然后重启服务 "Cannot open file for writing: Permissiondenied" bug info you maybe also encounter with the message when you try to modify themy.cn

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

"Cannot open file for writing: Permission denied"

bug info

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

show variables where `variable_name` = 'thread_stack';

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. 

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

皇牌天下投注网 1

解决

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

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

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'.

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

皇牌天下投注网 2

ERRNO: 256TEXT: 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.

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” .

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” .

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

可以使用

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 Error Code : 1436 Thread stack overrun

关键词:

上一篇:数据库优化

下一篇:没有了

最火资讯