1
there is the possibility of stop one stored proceduresin the MySQL? I put a procedures to power a database table for load testing with 10 million records, but the insertion is too slow and wanted to stop it without having to stop the server (there are other applications running on it).
3
try to establish a new connection with the database. If you have executed the procedures via PHPMyAdmin it will be necessary to use another browser, or close the current one completely before trying to enter the database again, as the server recognizes that you are still "waiting" to receive the response to your request.
Execute the command SHOW PROCESSLIST to see the processes. find your Storege Process that is running and use the command KILL.
Example:
SHOW PROCESSLIST; -- irá listar varios processos, veja o da sua procedure
KILL 749; -- no lugar do 749 coloque o ID do processo.
Browser other questions tagged mysql stored-procedures
You are not signed in. Login or sign up in order to post.