MySQL出错日志和通用查询日志(-)

fgew2

• 通用日志设置
  my.cnf配置如下
  general_log=on
  general_log_file=/opt/mysql/data/mysql_general.log
  以下是通过查看日志得到的，可以看到记录了所有的SQL及各种query
  
  [iyunv@hack data]# tail -f mysql_general.log
  /usr/local/mysql/bin/mysqld, Version: 5.6.14-log (Source distribution). started with:
  Tcp port: 3306  Unix socket: /usr/local/mysql/mysql.sock
  Time                 Id Command    Argument
  
  
  150417  0:53:55     1 Connect   root@localhost on
                      1 Query     select @@version_comment limit 1
  150417  0:53:59     1 Query     show databases
  150417  0:54:11     1 Query     select * from mysql.user
  150417  0:54:31     1 Query     select @@session.long_query_time
  mysql> show variables like '%general%';
  +------------------+-----------------------------------+
  | Variable_name    | Value                             |
  +------------------+-----------------------------------+
  | general_log      | ON                                |
  | general_log_file | /opt/mysql/data/mysql_general.log |
  +------------------+-----------------------------------+
  2 rows in set (0.10 sec)
  mysql> set @@session.general_log=off;
  ERROR 1229 (HY000): Variable 'general_log' is a GLOBAL variable and should be set with SET GLOBAL
  mysql> set @@global.general_log=off;
  Query OK, 0 rows affected (0.01 sec)
  
  mysql> 从这个也可以看到general_log为global参数
  
• 出错日志默认是开启的默认名为HOSTNAME.err 如果指定 log=/opt/mysql/data/mysql.log
  my.cnf配置 log-error=/opt/mysql/data/mysql.log
  
  [iyunv@hack data]# tail -200f mysql.log 可以看到该日志记录关闭和开启数据库数据
  150417 01:02:28 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/data
  2015-04-17 01:02:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  2015-04-17 01:02:55 2701 [Note] InnoDB: 5.6.14 started; log sequence number 13384393
  2015-04-17 01:02:56 2701 [Note] Server hostname (bind-address): '*'; port: 3306
  2015-04-17 01:02:57 2701 [Note] IPv6 is available.
  2015-04-17 01:02:57 2701 [Note]   - '::' resolves to '::';
  2015-04-17 01:02:57 2701 [Note] Server socket created on IP: '::'.
  2015-04-17 01:03:00 2701 [Note] Event Scheduler: Loaded 0 events
  2015-04-17 01:03:00 2701 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
  Version: '5.6.14-log'  socket: '/usr/local/mysql/mysql.sock'  port: 3306  Source distribution
  2015-04-17 01:04:41 2701 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown
  
  2015-04-17 01:04:41 2701 [Note] Giving 1 client threads a chance to die gracefully
  2015-04-17 01:04:41 2701 [Note] Event Scheduler: Purging the queue. 0 events
  2015-04-17 01:04:41 2701 [Note] Shutting down slave threads
  2015-04-17 01:04:43 2701 [Note] Forcefully disconnecting 1 remaining clients
  2015-04-17 01:04:43 2701 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 1  user: 'root'
  
  2015-04-17 01:04:43 2701 [Note] Binlog end
  2015-04-17 01:04:43 2701 [Note] Shutting down plugin 'partition'
  2015-04-17 01:04:43 2701 [Note] InnoDB: FTS optimize thread exiting.
  2015-04-17 01:04:43 2701 [Note] InnoDB: Starting shutdown...
  2015-04-17 01:04:44 2701 [Note] InnoDB: Shutdown completed; log sequence number 13415235
  2015-04-17 01:04:44 2701 [Note] Shutting down plugin 'binlog'
  2015-04-17 01:04:44 2701 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
  
  150417 01:04:45 mysqld_safe mysqld from pid file /opt/mysql/data/hack.pid ended
  
  关于error的参数
  
  mysql> show variables like '%error%';
  +--------------------+---------------------------+
  | Variable_name      | Value                     |
  +--------------------+---------------------------+
  | error_count        | 0                         |
  | log_error          | /opt/mysql/data/mysql.log |
  | max_connect_errors | 100                       |
  | max_error_count    | 64                        |
  | slave_skip_errors  | OFF                       |
  +--------------------+---------------------------+
  5 rows in set (0.00 sec)
  
  mysql>