MySQL Bugs: #52530: Workbench slow to connect to Server Administration

Bug #52530	Workbench slow to connect to Server Administration
Submitted:	1 Apr 2010 16:16	Modified:	2 Aug 2010 15:02
Reporter:	Bob Hansen	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S5 (Performance)
Version:	5.2.24	OS:	Any (XP Pro SP2, Ubuntu)
Assigned to:	Alexander Musienko	CPU Architecture:	Any
Tags:	databases, lots, many, server administration, slow, workbench

Description:
In Workbench, I can create and test a Server Instance just fine. When I go under Server Administration and double-click on the instance, it opens a new tab and begins to load data. The last time I tried this I gave up after waiting 5-10 minutes for it to load and eventually force quit the application. I use Desktop Sidebar which was showing 100% disk usage during that time.

All I was trying to do was to make a backup of a database but the screen never loaded. I am used to running MySQL Administrator which is very reasonable in load times. It can load and display a database within 10 seconds. 5-10+ minute wait seems unreasonable to me. Maybe today before I go to lunch I will open it up to see if it finishes loading by the time I come back.

I'm running MySQL Server 5.1.44. I've got about 80 databases on my server each with 100-500 InnoDB tables in them. I'm running an Athlon 64 3200+ with 2.5GB RAM.

How to repeat:
Populate server with databases.
Open Workbench.
Create new server instance.
Connect to new server instance in Server Administration.
Wait a very long time for the screen to load.

Suggested fix:
Possibly Workbench is trying to read all tables from all databases before it can even show the screen. I suggest to only get a list of databases first. Only read the contents of a database that the user actually wants to work with.

I forgot to add, after you go to Server Administration you have to click on the Data Dump button. 

I timed it earlier and it took about 10 minutes for the Export/Import options to display on screen after you click on Data Dump.

Thank you for the bug report. Could you please try the last released version 5.2.17?. Thanks in advance.

Tried 5.2.17 OSS Beta Revision 5565
I tried it and it takes about 11 1/2 minutes to load the screen on the Data Dump tab. That's about the same as the previous version.

Many thanks for writing a bug report.

Your guess is right:
"Possibly Workbench is trying to read all tables from all databases before it can even show the screen."

I activated general log and use:

$ tail -f HOSTNAME.log

Here are my steps:

1. Open Workbench
2. Double click on instance
3. Click Data Dump

Output from general log:
100624  9:13:38	   52 Query	SHOW CREATE DATABASE `db0`
		   52 Query	SHOW FULL TABLES FROM `db0`
		   52 Query	SHOW CREATE DATABASE `db1`
		   52 Query	SHOW FULL TABLES FROM `db1`
		   52 Query	SHOW CREATE DATABASE `db10`
		   52 Query	SHOW FULL TABLES FROM `db10`
		   52 Query	SHOW CREATE DATABASE `db11`
		   52 Query	SHOW FULL TABLES FROM `db11`
		   52 Query	SHOW CREATE DATABASE `db12`
		   52 Query	SHOW FULL TABLES FROM `db12`
		   52 Query	SHOW CREATE DATABASE `db13`
		   52 Query	SHOW FULL TABLES FROM `db13`
		   52 Query	SHOW CREATE DATABASE `db14`
		   52 Query	SHOW FULL TABLES FROM `db14`
		   52 Query	SHOW CREATE DATABASE `db15`
		   52 Query	SHOW FULL TABLES FROM `db15`
		   52 Query	SHOW CREATE DATABASE `db16`
		   52 Query	SHOW FULL TABLES FROM `db16`
		   52 Query	SHOW CREATE DATABASE `db17`
		   52 Query	SHOW FULL TABLES FROM `db17`
		   52 Query	SHOW CREATE DATABASE `db18`
		   52 Query	SHOW FULL TABLES FROM `db18`
		   52 Query	SHOW CREATE DATABASE `db19`
		   52 Query	SHOW FULL TABLES FROM `db19`
		   52 Query	SHOW CREATE DATABASE `db2`
		   52 Query	SHOW FULL TABLES FROM `db2`
		   52 Query	SHOW CREATE DATABASE `db20`
		   52 Query	SHOW FULL TABLES FROM `db20`
		   52 Query	SHOW CREATE DATABASE `db21`
		   52 Query	SHOW FULL TABLES FROM `db21`
		   52 Query	SHOW CREATE DATABASE `db22`
		   52 Query	SHOW FULL TABLES FROM `db22`
		   52 Query	SHOW CREATE DATABASE `db23`
		   52 Query	SHOW FULL TABLES FROM `db23`
....
		   52 Query	SHOW CREATE DATABASE `db95`
		   52 Query	SHOW FULL TABLES FROM `db95`
		   52 Query	SHOW CREATE DATABASE `db96`
		   52 Query	SHOW FULL TABLES FROM `db96`
		   52 Query	SHOW CREATE DATABASE `db97`
		   52 Query	SHOW FULL TABLES FROM `db97`
		   52 Query	SHOW CREATE DATABASE `db98`
		   52 Query	SHOW FULL TABLES FROM `db98`
		   52 Query	SHOW CREATE DATABASE `db99`
		   52 Query	SHOW FULL TABLES FROM `db99`
		   52 Query	SHOW CREATE DATABASE `miracee`
		   52 Query	SHOW FULL TABLES FROM `miracee`
		   52 Query	SHOW CREATE DATABASE `mysql`
		   52 Query	SHOW FULL TABLES FROM `mysql`
		   52 Query	SHOW CREATE DATABASE `test`
		   52 Query	SHOW FULL TABLES FROM `test`

Workbench really is asking for all tables in all schemas already before you choose a schema that you want to dump.

fix confirmed in repository

An entry has been added to the 5.2.26 changelog:

After creating a server instance and double-clicking it on the Home screen, the Administrator took an excessively long time to load (over 10 minutes).

Marked bug #55749 as duplicate