Re: slow response on listing tables in database

[Tony Freixas]

I'm seeing the same thing. If I start MySQL Administrator and look at server connections, I can see that the Query Browser is calling SHOW COLUMNS FROM 'sometable' and the spending about 2 to 3 seconds before going on to the next table. A lot of the time, MySQL Administrator shows the state as ***DEAD*** in between queries. I don't know what that means.

If I use MySQL Query Browser to connect to a MySQL 4 database, the schemas open up almost instantly. Everything had been working fine for MySQL 5.0.51a until recently. I have no idea what changed—I haven't updated MySQL or MySQL Query Browser for quite a while, so it must be an interaction with something else on the system.

Any ideas for debugging? The logs aren't useful—they just show one SHOW COLUMNS after another, with anywhere from 2 to 5 seconds in between each call.

All other operations seem to work OK. It's just opening or refreshing the schema.