mysql 数据库宕机问题解决

查看log,内容如下:
vim /var/log/mysqld.log

问题1:
2020-07-30T03:46:12.732170Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2020-07-30T03:46:13.431987Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200730 11:46:13

运行:
shell: mysql_upgrade –host=’127.0.0.1′ –port=3306 –user=’root’ –password=”root”

继续阅读“mysql 数据库宕机问题解决”

CentOS 7上MySQL 5.7.18莫名其妙Crash原因分析及解决

一、Centos中查看nginx、apache、php、mysql配置文件路径

1、判断apache
首先执行命令找到httpd路径
ps aux | grep httpd
如httpd路径为 /usr/local/apache/bin/httpd
然后执行以下命令
/usr/local/apache/bin/httpd -V | grep “SERVER_CONFIG_FILE”
即可找到编译时加载的配置文件路径 httpd.conf
-V 参数可以看到编译时配置的参数

继续阅读“CentOS 7上MySQL 5.7.18莫名其妙Crash原因分析及解决”