当前位置: 首页> 教育> 锐评 > 苏州网站建设系统电话_如何做企业网络营销推广_企业策划_搜索引擎排名影响因素有哪些

苏州网站建设系统电话_如何做企业网络营销推广_企业策划_搜索引擎排名影响因素有哪些

时间:2025/7/10 3:43:01来源:https://blog.csdn.net/seulk_Q/article/details/144999000 浏览次数:0次
苏州网站建设系统电话_如何做企业网络营销推广_企业策划_搜索引擎排名影响因素有哪些

# 问题:

查看从库MySQL日志发现有如下报错:

2025-01-08T08:45:55.637138+08:00 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade

# 原因:

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> select version();
+------------+
| version()  |
+------------+
| 5.7.28-log |
+------------+

TIPS:如果是生产数据库,先备份后再操作。

登录从库mysql:

show slave status\G;

stop slave ;

set global read_only=0;

set global super_read_only=0;

exit;

执行upgrade

mysql_upgrade --host='127.0.0.1' --port=3306 --user='root' --password='xxxx'

mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.engine_cost                                  OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.gtid_executed                                OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.server_cost                                  OK
mysql.servers                                      OK
mysql.slave_master_info                            OK
mysql.slave_relay_log_info                         OK
mysql.slave_worker_info                            OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Found outdated sys schema version 1.5.1.
Upgrading the sys schema.
Checking databases.

...

Upgrade process completed successfully.
Checking if update is needed.

登录MySQL,查看数据库是否正常

set global read_only=1;

set global super_read_only=1;

start slave ;

show slave status\G;

show processlist;

关键字:苏州网站建设系统电话_如何做企业网络营销推广_企业策划_搜索引擎排名影响因素有哪些

版权声明:

本网仅为发布的内容提供存储空间,不对发表、转载的内容提供任何形式的保证。凡本网注明“来源:XXX网络”的作品,均转载自其它媒体,著作权归作者所有,商业转载请联系作者获得授权,非商业转载请注明出处。

我们尊重并感谢每一位作者,均已注明文章来源和作者。如因作品内容、版权或其它问题,请及时与我们联系,联系邮箱:809451989@qq.com,投稿邮箱:809451989@qq.com

责任编辑: