...
Panel |
---|
mysql> select ROUTINE_DEFINITION from information_schema.ROUTINES where ROUTINE_NAME='procedure-name'; |
...
Show errors or warnings of just executed command
...
Panel |
---|
mysql> SHOW WARNINGS; |
...
Kill a sql process
...
To kill a heavy sql process: find the id of that process and kill it
Panel |
---|
mysql> SHOW FULL PROCESSLIST; |