MySQL(Log)

2019独角兽企业重金招聘Python工程师标准>>>

mysql option/variable location:
    cmd-line
    option-file
    system-variable
    status-variable
mysql option/variable scope:
    global
    session
    both
mysql option/variable dynamic:
    yes
    no

general log destination:
   --log-output = TABLE|FILE|NONE

error log:
  my.cnf
    log-error = /var/lib/mysql/mysqld.err
  cmd-line
    --log-error=[file-name]
  show system-var
    log_error=[file-name]
  no dynamic

query log(DQL):
  my.cnf
    general-log = /var/lib/mysql/query_log.log
  cmd-line
    general-log=[file-name]
  system-var
    set global general_log = on
    set global general_log_file = [file-name]
  dynamic

slow query log(slow DQL):
  my.cnf
    slow-query-log=[file-name]
  cmd-line
    --log-slow-queries=[file-name]
  system-var
    set global slow_query_log= ON
    set global slow_query_log_file=/var/lib/mysql/slow_query_log.log
  dynamic
  check tool: mysqldumpslow

update log:
  my.cnf
    log-update = /var/lib/mysql/update_log.log
  cmd-line
    --log-update=[file-name]
  no system-var
  no dynamic

bin log(DDL and DML, no DQL):
  my.cnf
    log-bin = /var/lib/mysql/bin_log.log
  cmd-line
    --log-bin=[file-name]
  show system-var
    log_bin = on
  no dynamic
  check tool: mysqlbinlog

relay log(slave recovery log):
  my.cnf
    relay-log = /var/lib/mysql/relay_log.log
  cmd-line
    --relay-log=[file-name]
  show system-var
    relay_log = on
  no dynamic
  check tool: mysqlbinlog

slave update log:
    my.cnf
      log-slave-updates = on
    cmd-line
      --log-slave-updates = on
    show system-var
      log_slave_updates
    no dynamic

audit log:
    my.cnf
      audit-log = on
      audit_log_file=[filename]
    cmd-line
      --audit-log = on
      --audit_log_file=[filename]
    show system-var
      audit_log = on
      audit_log_file=[filename]
    no dynamic

transaction coordinator log:
    my.cnf
      tc-log = [filename]
    cmd-line
      --tc-log = [filename]
    no system-var
    no dynamic

syslog log:
    my.cnf
      log_syslog = on
    cmd-line
      --log_syslog = on
    system-var
      set global log_syslog = on
    no dynamic

log raw(for query rewrite plugin)
    my.cnf
      log-raw = on
    cmd-line
      --log-syslog = on
    no system-var
    no dynamic
 

转载于:https://my.oschina.net/igooglezm/blog/823247