How can we capture the resource usage of a specific stored procedure in mysql server

Question

How to capture the resource usage of a specific stored procedure in MYSQL server, and how to get the query of its resource usage.

Answer 1

1. You can use Navicat (Tools -> Server Monitor) https:// www.navicat.com/en/products/navicat-for-mysql
2. Jet Profiler for Mysql: https://www.jetprofiler.com/
3. New Relic:https://newrelic.com

They all have trial versions.