Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Jim Lyons (jlyons4435gmail.com)
Date: Tue Nov 25 2008 - 11:17:02 CST
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.
Web developer / Database administrator