How to stop stored procedures in MySQL?

Navigation
1

Is it possible to stop a stored procedures in MySQL ? I put a procedures to feed a database table for load tests with 10 million records, however the insertion is very slow and I wanted to stop it without having to stop the server (there are other applications running on it).

    
asked by anonymous 26.02.2016 / 14:47

1 answer

3

try to establish a new connection to the bank. If you have run the procedures call via PHPMyAdmin you will need to use another browser, or close the current one completely before attempting to enter the database again, because the server acknowledges that you are still "waiting" to receive the response to your request.

Run the SHOW PROCESSLIST command to see the processes. find your store that is running and use the KILL command. Example: 

SHOW PROCESSLIST; -- irá listar varios processos, veja o da sua procedure

KILL 749; -- no lugar do 749 coloque o ID do processo.
    
26.02.2016 / 14:52
What are the free library options for ASP.NET MVC PDF generation? [closed] update ListView using notifyDataSetChanged ();