国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 數據庫 > MySQL > 正文

Mysql Error Code : 1436 Thread stack overrun

2024-07-24 13:03:03
字體:
來源:轉載
供稿:網友

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. 

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

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

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

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

"Cannot open file for writing: Permission denied"

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

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

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 瑞金市| 新沂市| 通海县| 磐石市| 汨罗市| 诏安县| 城口县| 基隆市| 孙吴县| 西丰县| 德令哈市| 东阳市| 富阳市| 罗江县| 奉新县| 嘉义县| 彩票| 睢宁县| 辽阳县| 夏邑县| 柏乡县| 九台市| 遂昌县| 金沙县| 甘肃省| 思茅市| 九龙县| 南宁市| 屏山县| 彭泽县| 蓬安县| 淳安县| 广南县| 龙江县| 宁陕县| 阿鲁科尔沁旗| 白城市| 富锦市| 灵石县| 长白| 南江县|