mysql/innodb_table_stats问题解决

 时间:2026-04-25 02:58:32

1、产生原因

根据提示:是数据库innodb_table_stats 表中table_name一栏长度异常导致的。

2、解决方法

1:执行mysl更新


mysql_upgrade --host=‘127.0.0.1’ --port=3306 --user=‘root’ --password=“root”
2:重启数据库mysql
service mysql restart

3、官网bug修改

mysql 官网Bug Fixed

Bugs Fixed

Important Change; Partitioning: After creating partitioned InnoDB tables with very long names, the table_name columns in the corresponding entries in the mysql.innodb_index_stats and mysql.innodb_table_stats system tables were truncated. To fix this issue, the length of the table_name column in each of these tables has been increased from 64 to 199 characters. In both cases, this is now the same as the lengths of these columns in MySQL 8.0.

When upgrading to this release, use mysql_upgrade to effect these changes in your MySQL installation. In the event that you fail to do this, MySQL generates the warning Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade in the error log.

  • 如何正确处理职业与事业的关系
  • 怎样显示隐藏的设备?
  • LinuxMint系统怎么设置启动屏保的等待时间?
  • 此计算机无法连接到远程计算机
  • 如何在Cesium中加载谷歌离线影像数据
  • 热门搜索
    送别诗手抄报 五年级数学手抄报内容 防电手抄报 防火手抄报图片 关于元旦的英语手抄报 小学生清明节的手抄报 古诗手抄报版面设计 传统文化手抄报模板 放飞梦想手抄报素材 校园礼仪手抄报