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
