Select query on information_schema is too slow
information_schema isn't a real database. To preform this query it needs to open tables.

The internal code for information_schema isn't optimized and it will frequently generate the data for the entire table requested without consideration of the query. As such your query could be opening every table regardless of the current table.