From: Jim Lyons (jlyons4435gmail.com)
Date: Tue Nov 25 2008 - 11:17:02 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

We have a pretty large database (several terabytes and hundreds of tables).
When I do a simple query from the information schema, e.g. select table_name
from tables, it can minutes to come back with the answer. Yet, if I do a
show tables, describe or "show create table" the response is instant.

Then other day I wanted to see if a trigger existed on a table so I tried to
access the appropriate table in infromation schema. It took so long that I
just ran mysqldump on the table with the --no-date and --triggers options
and I got the answer immediately.

Does anyone else have this problem? Is there something I can do to speed up
queries to IS? I know these are views, are they so complicated that it
takes forever to query them. This reduces their usefulness if true.

Thanks

--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]