Bug #39664 Opening schema with 4000+ tables takes 10+ minutes
Submitted: 26 Sep 2008 11:42 Modified: 20 Oct 2009 5:59
Reporter: Bogdan Kecman Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Administrator Severity:S5 (Performance)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any

[26 Sep 2008 11:42] Bogdan Kecman 
Description:
Opening schema in the Mysql Administrator or Mysql query Browser, takes over 10 minutes if the schema 4000+ tables.

How to repeat:
To reproduce in the administrator. 
Select catalogs so the schema's become visible. Select a schema with 4000 tables. 

To reproduce in the Qyery Browser.
Select schemata so the schema's become visible. Select a schema with 4000 tables.

Suggested fix:
.
[19 Feb 2009 14:59] Susanne Ebrecht 
Many thanks for writing a bug report.

We made a deeper analysis of this and figured out it is an expected behaviour.

The scaling is linear ... the more tables the more longer need it.

The reason is because of getting all informations from MySQL server.
[19 Feb 2009 15:50] Gunter Rombauts 
A bug or not - having to wait so long means in practice that the MySQL administrator is unusable.
Why can other tools show the tables much faster than the MySQL administrator? In my opinion, because the design can better handle this kind of situation.
Should't we adapt the design then?????????
[5 Oct 2009 7:39] Andrii Nikitin 
if MA wants to list tables - it needs to just use 'SHOW TABLES' which will finish in seconds. If MA does SHOW TABLE STATUS - it will open every table and actually is big performance impact on server with huge number of tables and causing much additional workload is wrong if table_cache is not big enough. 
In addition, MA may fetch table statistics in background if it really needed.
[20 Oct 2009 5:59] Susanne Ebrecht 
Many thanks for writing a bug report. We are on the way to implement full functionality of
MySQL Administrator into MySQL Workbench. We won't fix this anymore.

Lots of functionalities of MySQL Administrator are already implemented in Workbench 5.2
which will get GA soon.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/