2017-09-29T13:24:30.716454+08:0060 [Warning] Timeout waiting for reply of binlog (file: mysql-bin.000002, pos: 1699), semi-sync up to file , position 0.
这说明 BINLOG 未开启，检查 BINLOG 是否开启
mysql> show variables like 'log_%' -> ; +----------------------------------------+---------------------+ | Variable_name | Value | +----------------------------------------+---------------------+ | log_bin | OFF | | log_bin_basename || | log_bin_index || | log_bin_trust_function_creators | OFF | | log_bin_use_v1_row_events | OFF | | log_builtin_as_identified_by_password | OFF | | log_error | /var/log/mysqld.log | | log_error_verbosity | 3 | | log_output | FILE | | log_queries_not_using_indexes | OFF | | log_slave_updates | OFF | | log_slow_admin_statements | OFF | | log_slow_slave_statements | OFF | | log_statements_unsafe_for_binlog | ON | | log_syslog | OFF | | log_syslog_facility | daemon | | log_syslog_include_pid | ON | | log_syslog_tag || | log_throttle_queries_not_using_indexes | 0 | | log_timestamps | UTC | | log_warnings | 2 | +----------------------------------------+---------------------+ 21 rows in set (0.01 sec)
发现值为 OFF
编辑 my.cnf
vim /etc/my.cnf [mysqld] log-bin=mysql-bin server-id=1
重启
service mysql.serverstart
报错
dump data error: [Reason: 2017-09-29 14:42:14 [ERROR] - Could not exec:select * from information_schema.GLOBAL_STATUS where VARIABLE_NAME='Threads_running', return:The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for'show_compatibility_56' 2017-09-29 14:42:19 [ERROR] - Could not exec:select * from information_schema.GLOBAL_STATUS where VARIABLE_NAME='Threads_running', return:The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for'show_compatibility_56' 2017-09-29 14:42:24 [ERROR] - Could not exec:select * from information_schema.GLOBAL_STATUS where VARIABLE_NAME='Threads_running', return:The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for'show_compatibility_56' 2017-09-29 14:42:29 [ERROR] - Checking MySQL workload failed, please retry later ]
评论
0 条评论