跳转到主内容

Unified Manager — MySQL 日志发送,多 GB 的大错误日志

Views:
22
Visibility:
Public
Votes:
0
Category:
oncommand-unified-manager<a>1096996</a>
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 以上。在 OVA 中,可能会出现发生原因 问题。

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.