show table status vs show fields
Posted: 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!
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!