Skip to content

Conversation

@aarongable
Copy link
Contributor

@aarongable aarongable commented Apr 22, 2025

Version v1.5.0 was released in January 2020, over five years ago. We have attempted to update this package several times since then -- first to v1.6.0, later to v1.7.1 -- but have reverted the change due to nigh-inexplicable performance regressions each time. Since our last attempt, we believe we have addressed the underlying issue by truncating timestamps when we talk to the database (see #7556) so that our indices don't try to track nanosecond precision.

We are now ready to reattempt updating this package to v1.7.1 again. If that goes well, we will further update it to the newest version.

Fixes #5437
Part of #7872

@aarongable aarongable requested a review from a team as a code owner April 22, 2025 23:15
@jsha
Copy link
Contributor

jsha commented Apr 23, 2025

we believe we have addressed the underlying issue by truncating the timestamps that we write to the database (see #7556)

To be precise, this truncates timestamps on write, and also on querying.

Last time we tried this upgrade, it was to 1.7.1: #7006. I have a bit of a preference to try upgrading to 1.7.1 again, to minimize variables. That way if something goes wrong we are less likely to second guess ourselves, like "was there something new in 1.8 or 1.9 that did it?" Then hopefully the subsequent upgrade to 1.9.2 will be a nothingburger.

@aarongable aarongable changed the title Update go-sql-driver/mysql from v1.5.0 to v1.9.2 Update go-sql-driver/mysql from v1.5.0 to v1.7.1 Apr 23, 2025
@aarongable
Copy link
Contributor Author

@jsha I've downgraded this to v1.7.1, PTAL

@aarongable aarongable merged commit bc899ac into main Apr 25, 2025
12 checks passed
@aarongable aarongable deleted the update-go-sql-driver branch April 25, 2025 00:29
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Performance regression when upgrading go-sql-driver/mysql to v1.6.0

4 participants