Mysql stored procedures

Stored Procedures (sp).

One trick of loading a stored procedure in a mysql shell is to use sourece command.

You can check if a sp exists by show create procedure MY_PROC.

This is a good post about writing a sp to debug metadata lock issue https://www.percona.com/blog/quickly-troubleshooting-metadata-locks-mysql-5-7/