I've installed MySQL server with many databases that use the InnoDB engine. With lots of procedures in each DB,
proc table contains more than 250,000 rows and it becomes ultimately slow when I need to run a query like this one:
SHOW PROCEDURE STATUS WHERE db LIKE '%SomeDB%';
The above query takes more than 5 seconds to execure and tweaking MySQL configuration parameters such as
key_buffer_size (which where already large enough) made no difference. I've 256GB memory installed on my server and I don't think it is because of any kind of memory shortage, maybe some misconfiguration that I have no Idea about it. Any hint?