show table status vs show fields

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
jammerjam
Posts: 27
Joined: Wed 09 Jan 2008 22:56

show table status vs show fields

Post by jammerjam » Wed 09 Jan 2008 23:09

I'm evaluating MyDeveloper Studio and have run into a problem that, if unresolved, will leave me no choice but to continue my search.

I have a mySQL database with over 4,000 tables. If I connect to the database, it executes the command "show table status". This, along with the normal processing the server handles, makes the # connections grow to over 500...at which point I have to reboot mySQL.

Some other applications I've seen have the option to use "show fields" instead, which gets the information about what tables & fields are available a different way. I believe it gets a lot less info than "show table status".

Is this currently an option? If not can it be added?

Thanks!

Alexz
Devart Team
Posts: 165
Joined: Wed 10 Aug 2005 08:30

Post by Alexz » Thu 10 Jan 2008 16:11

Please provide some information about the problem to help us reproduce it:
1. What version of MyDeveloper do you use?
2. What version of MySQL server do you use?
3. Could you please specify the statement to create your connected user?
4. What exactly did you do with Database Explorer? Did you connect only or expand the Tables node?
5. Are you sure that there was 500 connections to server? How did you find it?

Post Reply