Bug 197833 - Connections to mysql database in 7.0 RC2 is VERY slow
Connections to mysql database in 7.0 RC2 is VERY slow
Status: RESOLVED WORKSFORME
Product: db
Classification: Unclassified
Component: MySQL
7.0
All Mac OS X
: P3 (vote)
: 7.2
Assigned To: Jaroslav Havlin
issues@db
: PERFORMANCE, PLAN
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2011-04-18 09:19 UTC by geraint
Modified: 2012-05-15 11:56 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description geraint 2011-04-18 09:19:52 UTC
These are the steps to recreate the problem:
1. Open RC2 (wait for any project scans etc. to finish)
2. Click on Services view tab
3. expand Databases and enter Master Password
4. choose existing jdbc mysql connection to open/connect - takes 43 seconds
5. Open specific schema to list tables - takes 43 seconds
6. All database queries also take > 30 seconds to execute

database server is on the same network connecting via port 3306 - machines are both quad core x64 ubuntu boxes.

In NetBeans 6.9.1 exactly the same connections and actions take only a fraction of a second.
Comment 1 geraint 2011-04-19 13:35:20 UTC
I found a partial explanation - I was using a locally defined host name 'dbserver' which was defined in my /etc/hosts file in the connection settings.

When I change this to a static IP address (from the host name) to jdbc:mysql://192.168.1.50:3306/defaultschema,  the connection is still very slow but opening up different schemas is almost instantaneous.

So its seems almost as though the initial set up of the jdbc driver is what is aking the time.  Not sure if that makes any sense?

Also I customise the MySQL (Connector/JDriver) and switch the driver file from 5.1.13 back to the 5.1.6 used in NetBeans 6.9.1. the performance is perfect again.

Hope this helps
Comment 2 geraint 2011-04-29 10:22:15 UTC
Just downloaded version 7.0 stable for MacOs and the same problem is seen here.

I fixed it by downloading version 5.1.16 of the DB connector from http://dev.mysql.com/downloads/connector/j/
Comment 3 Jiri Rechtacek 2011-04-29 12:13:13 UTC
geraint, thanks for your investigation. I'll push for upgrading MySQL Connector for up-to-date version.
Comment 4 Jaroslav Havlin 2012-05-15 11:56:23 UTC
Seems to work fine in NetBeans 7.2, which uses driver version 5.1.18.
Please reopen if problems remain. Thank you.


By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo