官网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.
解决MySQL Innodb分区表创建时表名过长导致被截断的问题,通过增加mysql.innodb_index_stats及mysql.innodb_table_stats表中table_name字段长度至199字符,确保兼容性并提供升级指南。
2712

被折叠的 条评论
为什么被折叠?



