MySQL update
How many of you are thinking of performing a MySQL update? With the most recent news about MySQL 9 being released on July 1st, we’d guess that number is more than just a couple.
MySQL 9.0.0 is no longer available for download and that’s for a good reason – the MySQL version was removed from the downloads page because Jean-François Gagné has disclosed the bug #115517.
Now, the MySQL bug seems to be private, but multiple individuals and companies like Percona have already dug into the issue and have opened the MySQL update issue PS-9306 as a result. According to MySQL themselves, MySQL update 9.0.0 has a critical issue when a very large amount of tables is at play. If developers would have a very large amount of tables they’re working with, As a result of the recent MySQL update, MySQL would crash without the opportunity to be restarted. Percona says that the limit of tables for this MySQL update bug to manifest is around 10,000, while MySQL says that the limit is around 8,000.
Regardless of what’s the case, the reason why we advise you to not upgrade MySQL to any version beyond 8.0.37 before this MySQL bug is fixed would be that the affected versions seem to start from MySQL 8.0.38. Percona has determined that some of the MySQL versions affected by this MySQL update bug include MySQL 8.0.38, MySQL 8.4.1, and MySQL 9.0.0, so it’s smart to avoid upgrading altogether for now. After all, a fix should be rolled out relatively quickly.
This MySQL bug can be reproduced by running the Bash script available on Percona’s Atlassian page.
The MySQL bug #115517 is related to newer versions of MySQL and their apparent inability to support more than 10,000 tables in a single database. If this many tables are being run under the affected MySQL versions, there’s a good chance that MySQL won’t even start altogether.
For now, be on the safe side and avoid upgrading MySQL beyond 8.0.37.
The MySQL update bug #115517 has to do with those running bigger data sets on newer versions of MySQL. If our MySQL instance runs a lot of tables, it could crash upon restart.
To our knowledge, not so far. That’s why you should be wary when upgrading MySQL Server beyond the version 8.0.37.
This MySQL bug was disclosed by Jean-François Gagné in the summer of 2024.
Dive deep into ways to best index your data and learn how to mysql if…
Dive deep into ways to load big data sets into MySQL with BreachDirectory. From MySQL…
Can the SQL EXPLAIN statement be a DoS vector and how to mitigate this threat?…
What is Cross Site Scripting, how does it work, and how can developers prevent it?…
BreachDirectory explains the risks of compressed files with a password on them for your infrastructure…
There have been rumors about a data breach targeting Schneider Electric. Did a data breach…