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 ?