重要!!!MySQL 9.0存在重大BUG!!

7/11日开源数据库软件服务商percona发布重要警告,最新的mysql版本存在重大bug,原文如下

Do Not Upgrade to Any Version of MySQL After 8.0.37

Warning!

Recently, Jean-François Gagné opened a bug on bug.mysql.com #115517; unfortunately, the bug is now private.

However, the bug looks quite serious. We at Percona have performed several tests and opened the issue PS-9306 to investigate the problem.

In short, what happens is that if you create a large number of tables, like 10000, the mysql daemon will crash at restart.

Currently, we have identified that the following versions are affected:

MySQL 8.0.38
MySQL 8.4.1
MySQL 9.0.0

We have not yet identified the root cause or a workaround. As such, we suggest that all users do not adopt any of the MySQL versions mentioned until a fix is released.

If you want to test it yourself, just install one of the mentioned MySQL versions and run a script like the one used in our issue PS-9306.

原文链接:https://www.percona.com/blog/do-not-upgrade-to-any-version-of-mysql-after-8-0-37/#

简而言之

 如果表的数量超过10000个,mysql可能会在重启时崩溃,该bug在MySQL 8.0.38
MySQL 8.4.1 MySQL 9.0.0 三个版本被确认。

图片

重要提醒!生产系统请不要升级到以上版本!

相关推荐

  1. MySQL重要进程

    2024-07-16 21:36:04       45 阅读
  2. mysql重构

    2024-07-16 21:36:04       39 阅读
  3. leetcode-存在重复元素

    2024-07-16 21:36:04       52 阅读
  4. 五花八门客户问题(BUG) - 重复打印

    2024-07-16 21:36:04       63 阅读
  5. mysql 中的一些重要函数

    2024-07-16 21:36:04       46 阅读

最近更新

  1. docker php8.1+nginx base 镜像 dockerfile 配置

    2024-07-16 21:36:04       67 阅读
  2. Could not load dynamic library ‘cudart64_100.dll‘

    2024-07-16 21:36:04       72 阅读
  3. 在Django里面运行非项目文件

    2024-07-16 21:36:04       58 阅读
  4. Python语言-面向对象

    2024-07-16 21:36:04       69 阅读

热门阅读

  1. c++二叉搜索数模拟实现(代码)

    2024-07-16 21:36:04       18 阅读
  2. C#面 :dot net core工程里面有哪些常见的工程文件?

    2024-07-16 21:36:04       17 阅读
  3. docker部署项目命令

    2024-07-16 21:36:04       20 阅读
  4. ns3-gym入门(二):linear-mesh例子详解

    2024-07-16 21:36:04       16 阅读
  5. 数据结构与算法-09贪心算法&动态规划

    2024-07-16 21:36:04       16 阅读
  6. 访问者模式(大话设计模式)C/C++版本

    2024-07-16 21:36:04       17 阅读
  7. Logstash常用的filter四大插件

    2024-07-16 21:36:04       18 阅读
  8. RTOS中断与任务的同步

    2024-07-16 21:36:04       19 阅读
  9. 哈希表(知识点+leetcode)以及字符串哈希

    2024-07-16 21:36:04       21 阅读
  10. 运维检查:mysql表自增id是否快要用完

    2024-07-16 21:36:04       19 阅读
  11. C++设计模式(装饰器模式)

    2024-07-16 21:36:04       18 阅读
  12. 哪些点权衡素材优秀与否

    2024-07-16 21:36:04       18 阅读
  13. 前端反显后端图片、上传预览图片

    2024-07-16 21:36:04       19 阅读