Improving performance when quering information_schema

When running on a database server with a large information_schema database, this query is abnormally long, optimised per http://dev.mysql.com/doc/refman/5.6/en/information-schema-optimization.html