Get the total count of stored procedures in MySQL database

Below is the query to get the total count of stored procedures in MySQL database:

SELECT Count(ROUTINE_NAME)
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE="PROCEDURE" 
AND ROUTINE_SCHEMA="YourDBName";

Replace YourDBName with your actual db name.