# Performance issue due to heavy use of mysql.proc

**URL:** <https://forums.percona.com/t/performance-issue-due-to-heavy-use-of-mysql-proc/29655>\
**Category:** MySQL & MariaDB\
**Tags:** mysql, closed-no-reply\
**Created:** [April 11, 2024, 12:02am UTC](https://forums.percona.com/t/performance-issue-due-to-heavy-use-of-mysql-proc/29655 "2024-04-11T00:02:30Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![erpramodprajapat](https://avatars.discourse-cdn.com/v4/letter/e/c37758/32.png) [@erpramodprajapat](https://forums.percona.com/u/erpramodprajapat)\
**Post date:** [April 11, 2024, 12:02am UTC](https://forums.percona.com/t/performance-issue-due-to-heavy-use-of-mysql-proc/29655/1 "2024-04-11T00:02:30Z")

</div>

Whenever we are querying process list there some queries we can see like **SELECT db, name, type, comment FROM mysql.proc where db=‘test’ and name like ‘test\_proc’ ORDER BY name, type**  
and when the load increases all threads are showing this query only with different proc name and and CPU going to 100% and in cpu only system CPU is high 70~80 %  
Also this query show taking 100ms~200ms

we are having 2000 procedures

why this query need to executed and how we can resolve this ?