MySQL查看日誌，mysql日誌

MySQL查看日誌，mysql日誌

1、查看MySQL日誌

mysql> show global variables like '%log%';+-----------------------------------------+-------------------------+| Variable_name                           | Value                   |+-----------------------------------------+-------------------------+| back_log                                | 80                      || binlog_cache_size                       | 32768                   || binlog_checksum                         | CRC32                   || binlog_direct_non_transactional_updates | OFF                     || binlog_error_action                     | IGNORE_ERROR            || binlog_format                           | STATEMENT               || binlog_gtid_simple_recovery             | OFF                     || binlog_max_flush_queue_time             | 0                       || binlog_order_commits                    | ON                      || binlog_row_image                        | FULL                    || binlog_rows_query_log_events            | OFF                     || binlog_stmt_cache_size                  | 32768                   || binlogging_impossible_mode              | IGNORE_ERROR            || expire_logs_days                        | 0                       || general_log                             | OFF                     || general_log_file                        | 2014-0831-1223.log      || innodb_api_enable_binlog                | OFF                     || innodb_flush_log_at_timeout             | 1                       || innodb_flush_log_at_trx_commit          | 1                       || innodb_locks_unsafe_for_binlog          | OFF                     || innodb_log_buffer_size                  | 5242880                 || innodb_log_compressed_pages             | ON                      || innodb_log_file_size                    | 50331648                || innodb_log_files_in_group               | 2                       || innodb_log_group_home_dir               | .\                      || innodb_mirrored_log_groups              | 1                       || innodb_online_alter_log_max_size        | 134217728               || innodb_undo_logs                        | 128                     || log_bin                                 | OFF                     || log_bin_basename                        |                         || log_bin_index                           |                         || log_bin_trust_function_creators         | OFF                     || log_bin_use_v1_row_events               | OFF                     || log_error                               | .\2014-0831-1223.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                       || max_binlog_cache_size                   | 18446744073709547520    || max_binlog_size                         | 1073741824              || max_binlog_stmt_cache_size              | 18446744073709547520    || max_relay_log_size                      | 0                       || relay_log                               |                         || relay_log_basename                      |                         || relay_log_index                         |                         || relay_log_info_file                     | relay-log.info          || relay_log_info_repository               | FILE                    || relay_log_purge                         | ON                      || relay_log_recovery                      | OFF                     || relay_log_space_limit                   | 0                       || simplified_binlog_gtid_recovery         | OFF                     || slow_query_log                          | ON                      || slow_query_log_file                     | 2014-0831-1223-slow.log || sql_log_bin                             | ON                      || sql_log_off                             | OFF                     || sync_binlog                             | 0                       || sync_relay_log                          | 10000                   || sync_relay_log_info                     | 10000                   |+-----------------------------------------+-------------------------+61 rows in set (0.00 sec)mysql>

2、查看MySQL是否啟用日誌

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_error                              | .\2014-0831-1223.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                    |+----------------------------------------+----------------------+13 rows in set (0.00 sec)mysql>

3、查看MySQL當前的日誌

mysql> show master status;Empty set (0.00 sec)

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。