查看mysql有没有开binlog_MySQL开启binlog以及查看binlog

mysql> show variables like 'log_%';

+----------------------------------------+-----------------------------+

| Variable_name                          | Value                       |

+----------------------------------------+-----------------------------+

| log_bin                                | ON                          |

| log_bin_basename                       | /var/lib/mysql/binlog       |

| log_bin_index                          | /var/lib/mysql/binlog.index |

| log_bin_trust_function_creators        | OFF                         |

| log_bin_use_v1_row_events              | OFF                         |

| log_error                              | /var/lib/mysql/ace.err      |

| log_output                             | FILE                        |

| log_queries_not_using_indexes          | OFF                         |

| log_slave_updates                      | OFF                         |

| log_slow_admin_statements              | OFF                         |

| log_slow_slave_statements              | OFF                         |

| log_throttle_queries_not_using_indexes | 0                           |

| log_warnings                           | 1                           |

+----------------------------------------+-----------------------------+ log-bin=/var/lib/mysql/binlog