随笔分类 -  mysql-故障处理

ERROR 1030 (HY000): Got error 1 from storage engine
摘要：今天很搞笑的遇到了一个问题 ，启用半同步插件竟然报错，ERROR 1030 (HY000): Got error 1 from storage engine 1.现象mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master. 阅读全文
posted @ 2020-03-17 16:21 刘启武 阅读(2215) 评论(0) 推荐(0)
8.0.18 错误日志时间慢了8个小时
摘要：8.0.18 错误日志时间慢了8个小时2019-10-29T07:58:56.684916Z 0 [Note] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to 192.xxx.xxx 阅读全文
posted @ 2019-10-29 16:59 刘启武 阅读(390) 评论(0) 推荐(0)
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
摘要：mysql> select concat("kill ",id,";") from information_schema.PROCESSLIST where command="Query" or command="Execute" into outfile "/tmp/kill.sql";ERROR 阅读全文
posted @ 2019-07-12 14:28 刘启武 阅读(470) 评论(0) 推荐(0)