#4910 (ok 4.5) Insane slow

[Mauricio Ramirez]

Hi!

The problem I have pinpointed is the access to the information_schema.routines when you have , like me 1000 databases en 35000 routines declared.

What to do?

This query takes forever:

SELECT COUNT(*) FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA COLLATE utf8_bin= ...

Thanks for the development of such a great tool.

Mauricio Ramirez

[Marc Delisle]

Which MySQL version?

[Mauricio Ramirez]

5.5.43-0ubuntu0.14.04.1
and
5.5.34-log in Windows Server 2012 R2

[Madhura Jayaratne]

Try using $cfg['Servers'][$i]['DisableIS'] = true; for the relevant server in your config.inc.php. This should stop using information_schema for loading navigation panel (which executes the query you have quoted). However, 'Routines' page will still use information_schema.