跳转到主内容

NetApp_Insight_2020.png 

Unified Manager - MySQL 日志垃圾邮件、几 GB 的大错误日志

Views:
5
Visibility:
Public
Votes:
0
Category:
oncommand-unified-manager
Specialty:
om
Last Updated:

适用于

Unified Manager 9.4/9.5

问题

主要是在从低于 5.7.23 的旧 MySQL 版本升级之后,我们看到的错误似乎对 MySQL 错误日志没有功能影响。安装驱动器上的可用容量可能会受到影响,因为日志未旋转并且可能会增长无限。它还会导致在处理收集文件的支持包时出现问题。它可能非常庞大—而不是因为数据库。
数据目录中的相关 MySQL 错误日志名为 [SERVER_NAME].ERR 。

日志的位置
RHEL/CentOS/OVA
/var/log/mysql/error.log or /opt/netapp/data/mysql/[server_name].err
Windows standard path
[install drive]:\ProgramData\MYSQL\MySQLServerData\Data\[server_name].err


通过邮件(例如)收到垃圾邮件,因此日志
2019-10-29T02:35:50.450367Z 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-29T02:35:50.452470Z 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-29T02:35:50.454512Z 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-29T02:35:50.461723Z 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-29T02:35:50.464300Z 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade


可能会增长到超过 10 GB 的大小。在卵子中,它可能会导致问题。

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support