Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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;
mysql> SHOW ERRORS;

...

Kill a sql process

...

To kill a heavy sql process: find the id of that process and kill it

Panel

mysql> SHOW FULL PROCESSLIST;
mysql> KILL theprocessid;