Bug #80030 Connector/NET slow connecting to newer MySQL versions with pooling disabled
| Submitted: | 18 Jan 2016 10:32 | Modified: | 31 Jul 2018 14:43 |
|---|---|---|---|
| Reporter: | Jan Reilink | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / NET | Severity: | S2 (Serious) |
| Version: | 6.9.8.0 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | Connector/Net, slow | ||
[18 Jan 2016 10:32]
Jan Reilink
[18 Jan 2016 11:09]
Onno Molenkamp
The delay is caused by the new connection attribute feature, and specifically the code that determines the OS details. It uses an (inefficient) WMI-query for this, which can be very slow.
[18 Jan 2016 11:10]
Onno Molenkamp
This change makes connecting to a server that supports connection attributes significantly faster
Attachment: mysql-connector-net-slowness.patch (text/x-patch), 636 bytes.
[21 Jan 2016 12:18]
Chiranjeevi Battula
Hello Jan Reilink, Thank you for the bug report and test case. Verified this behavior on Visual Studio 2013 (C#.Net) with MySQL Connector/Net 6.9.8. Thanks, Chiranjeevi.
[21 Jan 2016 12:19]
Chiranjeevi Battula
Test Results
Attachment: 80030.zip (application/zip, text), 4.82 KiB.
[4 Jul 2016 16:22]
Pedro Borges
Do you have a timeline for merging this patch?
[7 Sep 2016 10:06]
NOT_FOUND NOT_FOUND
these client properties should be queried only once at startup, because they are invariant during the process lifetime
Attachment: 0001-client-properties-performance.patch (application/octet-stream, text), 6.93 KiB.
[7 Sep 2016 10:30]
Michiel Hazelhof
Nice patch, please incorporate the earlier patch as wel: "SELECT Caption FROM Win32_OperatingSystem"
[31 Jul 2018 14:43]
Christine Cole
Posted by developer: Fixed as of the upcoming MySQL Connector/NET 6.10.8 and 8.0.13 releases, and here's the changelog entry: Slow connections made to MySQL were improved by reducing the frequency and scope of operating system details required by the server to establish and maintain a connection. Thank you for the bug report.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.076 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.