Mysql Error Code : 1436 Thread stack overrun
I meet with the error while calling stored procedures from the MySql in my Mac system server. It similar as the description below
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.
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

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



OPStack is an open source blockchain framework released by Optimism Collective, the development group behind the Optimism Network. It is an important tool for both the Ethereum and Optimism communities. The main goal of OPStack is to strengthen the Optimism Network, providing key software tools to the Optimism Mainnet, as well as the upcoming Optimism Superchain and its governance model. By providing a developer-oriented environment, the core idea of OPStack is to promote growth and innovation in the Ethereum space. It paves the way for cutting-edge developments and makes blockchain creation simpler. OPStac

There are two ways to implement multi-threading in Java, one is to inherit the Thread class, and the other is to implement the Runnable interface; the Thread class is defined in the java.lang package. As long as a class inherits the Thread class and overrides the run() method in this class, it can implement multi-threaded operations. However, a class can only inherit one parent class, which is a limitation of this method. Let’s look at an example: packageorg.thread.demo;classMyThreadextendsThread{privateStringname;publicMyThread(Stringname){super();this

Java uses the empty() function of the Stack class to determine whether the stack is empty. The stack (Stack) is a common data structure that follows the first-in, last-out (FILO) principle. In Java, we can use the Stack class to implement the functionality of the stack. The Stack class provides a series of methods to operate the stack. One of the commonly used methods is the empty() function, which is used to determine whether the stack is empty. In Java, the Stack class is located in the java.util package. To use this class, you need

Use Java's Thread.start() function to start a new thread. In Java, we can use multi-threading to execute multiple tasks concurrently. Java provides the Thread class to create and manage threads. The start() function in the Thread class is used to start a new thread and execute the code in the run() method of the thread. Code example: publicclassMyThreadextendsThread{@Overr

In java, when it comes to threads, Thread is essential. A thread is a lighter scheduled executor than a process. Why use threads? By using threads, you can separate resource allocation and execution scheduling in operating system processes. Each thread can not only share process resources (memory address, file I/O, etc.), but can also be scheduled independently (thread is the basic unit of CPU scheduling). Note 1. Thread is the most important class for making threads, and the word itself also represents thread. 2. The Thread class implements the Runnable interface. Instance publicclassThreadDemoextendsThread{publicvoidrun(){for(inti=0

Introduces how to use the Stack function to perform basic stack operations in Java and related precautions. The stack is a commonly used data structure. In Java, you can use the Stack function to perform basic stack operations. Stack is a defined class located under the java.util package, so you need to introduce this package before using it. The following are the basic operations commonly used by the Stack class: 1. Create a stack Stack<Integer>stack=newStack

Java uses the start() function of the Thread class to start a new thread. In Java, multi-threading is a concurrent execution method that can perform multiple tasks at the same time. In order to implement multi-threading, the Thread class is provided in Java, through which threads are created and controlled. Among them, the start() function is used to start a new thread. The function of the start() function is to put the thread into the ready state and automatically call the thread's run() method. When a thread calls start(

Concept of SPL Data Structures PHPSPL (Standard PHP Library) contains a set of data structures and iterator classes designed to enhance PHP's native data types. These structures are optimized to efficiently store and manipulate a variety of data and provide a consistent interface and flexible iteration mechanism. Core SPL Data Structures The SPL library provides a variety of data structures, including: LinkedList: a doubly linked list that allows fast insertion, deletion, and search. Stack: Last-in-first-out (LIFO) data structure for stack operations. Queue: First-in-first-out (FIFO) data structure for queue operations. Map: A collection of key-value pairs, providing efficient key lookup and data storage. Set: unique value collection, supports fast member lookup and collection
