mysql 的日志

日志：
        查询日志：general_log
        慢查询日志：log_slow_queries
        错误日志：log_error， log_warnings
        二进制日志：binlog
        中继日志：relay_log
        事务日志：innodb_log
        
        1、查询日志
            记录查询语句，日志存储位置：
                文件：file
                表：table (mysql.general_log)
                
            general_log={ON|OFF}
            general_log_file=HOSTNAME.log 
            log_output={FILE|TABLE|NONE}
            
        2、慢查询日志
            慢查询：运行时间超出指定时长的查询；
                long_query_time
            存储位置：
                文件：FILE
                表：TABLE，mysql.slog_log
                
            log_slow_queries={ON|OFF}
            slow_query_log={ON|OFF}
            slow_query_log_file=
            log_output={FILE|TABLE|NONE}
            log_slow_filter=admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
            log_slow_rate_limit
            log_slow_verbosity
            
        3、错误日志
            记录如下几类信息：
                (1) mysqld启动和关闭过程中输出的信息； 
                (2) mysqld运行中产生的错误信息； 
                (3) event scheduler运行时产生的信息；
                (4) 主从复制架构中，从服务器复制线程启动时产生的日志；
                
            log_error=
                /var/log/mariadb/mariadb.log|OFF
            log_warnings={ON|OFF}
            
        4、二进制日志
            用于记录引起数据改变或存在引起数据改变的潜在可能性的语句（STATEMENT）或改变后的结果（ROW），也可能是二者混合；
            功用：“重放”
            
            binlog_format={STATEMENT|ROW|MIXED}
                STATEMENT：语句；
                ROW：行；
                MIXED：混编；
                
            查看二进制日志文件列表：
                 SHOW MASTER|BINARY LOGS;
                 
            查看当前正在使用的二进制日志文件：
                SHOW MASTER STATUS；
                
            查看二进制 日志文件中的事件：
                SHOW BINLOG EVENTS   [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
                
            服务器变量：
                log_bin=/PATH/TO/BIN_LOG_FILE
                    只读变量；
                session.sql_log_bin={ON|OFF}
                    控制某会话中的“写”操作语句是否会被记录于日志文件中；
                max_binlog_size=1073741824
                sync_binlog={1|0}
                
            mysqlbinlog：
                    YYYY-MM-DD hh:mm:ss
                
                 --start-datetime=
                 --stop-datetime=
                 
                 -j, --start-position=#
                  --stop-position=#
                  
                  --user, --host, --password

    在mysql数据库里有一张表专门用来保存查询日志的
MariaDB [mysql]> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| event                     |
| func                      |
| general_log               |   保存查询日志的表
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| host                      |
| ndb_binlog_index          |
| plugin                    |
| proc                      |
| procs_priv                |
| proxies_priv              |
| servers                   |
| slow_log                  |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
24 rows in set (0.04 sec)
查询日志如何启用他们，通过修改服务器变量
 查看服务器全局变量关于查询日志的变量
MariaDB [mysql]> show global variables like 'general%';
+------------------+-------------+
| Variable_name    | Value       |
+------------------+-------------+
| general_log      | OFF         |  默认是关闭的，生产中也建议关闭
| general_log_file | centos7.log |
+------------------+-------------+
2 rows in set (0.01 sec)
MariaDB [mysql]> show global variables like 'log_output';  
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_output    | FILE  |  定义日志输出到何处
+---------------+-------+
1 row in set (0.01 sec)
MariaDB [mysql]> set global general_log=ON;  打开查询日志的；次变量是全局变量
Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> show global variables like 'general%';  查看是否打开
+------------------+-------------+
| Variable_name    | Value       |
+------------------+-------------+
| general_log      | ON          |  查询日志已经打开
| general_log_file | centos7.log |
+------------------+-------------+
2 rows in set (0.00 sec)
MariaDB [mysql]> select * from mydb.students where stuid=3; 执行一个查询语句查看
+-------+----------+------+--------+-------------+
| stuid | name     | age  | gender | major       |
+-------+----------+------+--------+-------------+
|     3 | jingtian |   35 | F      | chuiniudafa |
+-------+----------+------+--------+-------------+
1 row in set (0.00 sec)
[root@centos7 ~]# ls /var/lib/mysql/
aria_log.00000001  centos7.log    生成的查询文件  ib_logfile0  mydb   mysql.sock          test
aria_log_control   ibdata1      ib_logfile1  mysql  performance_schema
关闭查询日志
MariaDB [mysql]> set @@global.general_log=OFF;
Query OK, 0 rows affected (0.00 sec)、
慢查询日志的相关设定
MariaDB [mysql]> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| event                     |
| func                      |
| general_log               |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| host                      |
| ndb_binlog_index          |
| plugin                    |
| proc                      |
| procs_priv                |
| proxies_priv              |
| servers                   |
| slow_log                  |  慢查询日志记录的表
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
24 rows in set (0.00 sec)
查看关于慢查询日志的社定

MariaDB [mysql]> show global variables like '%slow%';
+---------------------+--------------------------------------------------------------------------------------------------------------+
| Variable_name       | Value                                                                                                        |
+---------------------+--------------------------------------------------------------------------------------------------------------+
| log_slow_filter     | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk |
| log_slow_queries    | OFF                                                                                                          |
| log_slow_rate_limit | 1                                                                                                            |
| log_slow_verbosity  |                                                                                                              |
| slow_launch_time    | 2                                                                                                            |
| slow_query_log      | OFF                                                                                                          |
| slow_query_log_file | centos7-slow.log                                                                                             |
+---------------------+--------------------------------------------------------------------------------------------------------------+
7 rows in set (0.00 sec)

MariaDB [mysql]> set global slow_query_log=ON; 打开慢查询日志功能
MariaDB [mysql]> set @@global.log_output='FILE'; 设定将main查询日志保存至文件中
Query OK, 0 rows affected (0.01 sec)
错误日志的相管的
MariaDB [mysql]> show global variables like '%error%';
+--------------------+------------------------------+
| Variable_name      | Value                        |
+--------------------+------------------------------+
| log_error          | /var/log/mariadb/mariadb.log |
| max_connect_errors | 10                           |
| max_error_count    | 64                           |
| slave_skip_errors  | OFF                          |
+--------------------+------------------------------+
4 rows in set (0.01 sec)

二进制日志

MariaDB [mysql]> show global variables like 'binlog_format';
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| binlog_format | STATEMENT |
+---------------+-----------+
1 row in set (0.00 sec)

MariaDB [mysql]> show master logs;  查看跟踪日志
ERROR 1381 (HY000): You are not using binary logging
二进制日志不支持启动时修改

[root@centos7 ~]# vim /etc/my.cnf.d/server.cnf  修改文件

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]
log-bin=master-log  设置启用二进制日志
# this is only for embedded server
[embedded]

# This group is only read by MariaDB-5.5 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mysqld-5.5]

# These two groups are only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

[mariadb-5.5]
查看上一个事物的结束点
MariaDB [(none)]>  show master status;
+-------------------+----------+--------------+------------------+
| File              | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+-------------------+----------+--------------+------------------+
| master-log.000001 |      245 |              |                  |
+-------------------+----------+--------------+------------------+
MariaDB [mydb]> delete from students where stuid=1980;  删除一条数据是都会引起二进制日志变化
Query OK, 1 row affected (0.00 sec)
MariaDB [mydb]>  show master status; 再次查看
+-------------------+----------+--------------+------------------+
| File              | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+-------------------+----------+--------------+------------------+
| master-log.000001 |      440 |              |                  |
+-------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
MariaDB [mydb]> show binlog events;
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
| Log_name          | Pos | Event_type  | Server_id | End_log_pos | Info                                              |
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
| master-log.000001 |   4 | Format_desc |         1 |         245 | Server ver: 5.5.52-MariaDB, Binlog ver: 4         |
| master-log.000001 | 245 | Query       |         1 |         313 | BEGIN                                             |
| master-log.000001 | 313 | Query       |         1 |         413 | use `mydb`; delete from students where stuid=1980 |
| master-log.000001 | 413 | Xid         |         1 |         440 | COMMIT /* xid=18 */                               |
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
4 rows in set (0.00 sec)
手动滚动二进制日志文件
MariaDB [mydb]> flush logs;
Query OK, 0 rows affected (0.04 sec)
删除一条数据
MariaDB [mydb]> delete from students where stuid=1987;
Query OK, 1 row affected (0.03 sec)
查看是否滚动的二进制日志文件
MariaDB [mydb]> show master logs;
+-------------------+-----------+
| Log_name          | File_size |
+-------------------+-----------+
| master-log.000001 |       874 |
| master-log.000002 |       440 |
+-------------------+-----------+
2 rows in set (0.00 sec)
MariaDB [mydb]> show master status;  查看当前使用的文件
+-------------------+----------+--------------+------------------+
| File              | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+-------------------+----------+--------------+------------------+
| master-log.000002 |      440 |              |                  |
+-------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

MariaDB [mydb]> show binlog events; 默认查看的第一个日志文件
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
| Log_name          | Pos | Event_type  | Server_id | End_log_pos | Info                                              |
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
| master-log.000001 |   4 | Format_desc |         1 |         245 | Server ver: 5.5.52-MariaDB, Binlog ver: 4         |
| master-log.000001 | 245 | Query       |         1 |         313 | BEGIN                                             |
| master-log.000001 | 313 | Query       |         1 |         413 | use `mydb`; delete from students where stuid=1980 |
| master-log.000001 | 413 | Xid         |         1 |         440 | COMMIT /* xid=18 */                               |
| master-log.000001 | 440 | Query       |         1 |         508 | BEGIN                                             |
| master-log.000001 | 508 | Query       |         1 |         608 | use `mydb`; delete from students where stuid=1989 |
| master-log.000001 | 608 | Xid         |         1 |         635 | COMMIT /* xid=23 */                               |
| master-log.000001 | 635 | Query       |         1 |         703 | BEGIN                                             |
| master-log.000001 | 703 | Query       |         1 |         803 | use `mydb`; delete from students where stuid=1986 |
| master-log.000001 | 803 | Xid         |         1 |         830 | COMMIT /* xid=29 */                               |
| master-log.000001 | 830 | Rotate      |         1 |         874 | master-log.000002;pos=4                           |
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
11 rows in set (0.00 sec)
MariaDB [mydb]> show binlog events in 'master-log.000002'; 手动指定要查看的文件 
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
| Log_name          | Pos | Event_type  | Server_id | End_log_pos | Info                                              |
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
| master-log.000002 |   4 | Format_desc |         1 |         245 | Server ver: 5.5.52-MariaDB, Binlog ver: 4         |
| master-log.000002 | 245 | Query       |         1 |         313 | BEGIN                                             |
| master-log.000002 | 313 | Query       |         1 |         413 | use `mydb`; delete from students where stuid=1987 |
| master-log.000002 | 413 | Xid         |         1 |         440 | COMMIT /* xid=32 */                               |
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
4 rows in set (0.00 sec)
MariaDB [mydb]> set @@session.sql_log_bin=OFF;  会话级别临时关闭二进制功能
Query OK, 0 rows affected (0.01 sec)
MariaDB [mydb]> delete from students where stuid=1956; 删除一条数据
Query OK, 1 row affected (0.01 sec)

MariaDB [mydb]> show binlog events in 'master-log.000002'; 查看日志是否被记录
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
| Log_name          | Pos | Event_type  | Server_id | End_log_pos | Info                                              |
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
| master-log.000002 |   4 | Format_desc |         1 |         245 | Server ver: 5.5.52-MariaDB, Binlog ver: 4         |
| master-log.000002 | 245 | Query       |         1 |         313 | BEGIN                                             |
| master-log.000002 | 313 | Query       |         1 |         413 | use `mydb`; delete from students where stuid=1987 |
| master-log.000002 | 413 | Xid         |         1 |         440 | COMMIT /* xid=32 */                               |
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
4 rows in set (0.00 sec)

MariaDB [mydb]> set @@session.sql_log_bin=ON;  会话级别打开该功能
Query OK, 0 rows affected (0.00 sec)
MariaDB [mydb]> delete from students where stuid=1957;  再删除一条记录
Query OK, 1 row affected (0.01 sec)

MariaDB [mydb]> show binlog events in 'master-log.000002'; 二进制日志又被滚动了
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
| Log_name          | Pos | Event_type  | Server_id | End_log_pos | Info                                              |
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
| master-log.000002 |   4 | Format_desc |         1 |         245 | Server ver: 5.5.52-MariaDB, Binlog ver: 4         |
| master-log.000002 | 245 | Query       |         1 |         313 | BEGIN                                             |
| master-log.000002 | 313 | Query       |         1 |         413 | use `mydb`; delete from students where stuid=1987 |
| master-log.000002 | 413 | Xid         |         1 |         440 | COMMIT /* xid=32 */                               |
| master-log.000002 | 440 | Query       |         1 |         508 | BEGIN                                             |
| master-log.000002 | 508 | Query       |         1 |         608 | use `mydb`; delete from students where stuid=1957 |
| master-log.000002 | 608 | Xid         |         1 |         635 | COMMIT /* xid=44 */                               |
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------+
7 rows in set (0.00 sec)

MariaDB [mydb]> show binlog events in 'master-log.000002'  from 440; 只显示440之后的
+-------------------+-----+------------+-----------+-------------+---------------------------------------------------+
| Log_name          | Pos | Event_type | Server_id | End_log_pos | Info                                              |
+-------------------+-----+------------+-----------+-------------+---------------------------------------------------+
| master-log.000002 | 440 | Query      |         1 |         508 | BEGIN                                             |
| master-log.000002 | 508 | Query      |         1 |         608 | use `mydb`; delete from students where stuid=1957 |
| master-log.000002 | 608 | Xid        |         1 |         635 | COMMIT /* xid=44 */                               |
+-------------------+-----+------------+-----------+-------------+---------------------------------------------------+
3 rows in set (0.00 sec)
MariaDB [mydb]> show binlog events in 'master-log.000002'  from 440 limit 1;  表示只显示440的一行
+-------------------+-----+------------+-----------+-------------+-------+
| Log_name          | Pos | Event_type | Server_id | End_log_pos | Info  |
+-------------------+-----+------------+-----------+-------------+-------+
| master-log.000002 | 440 | Query      |         1 |         508 | BEGIN |
+-------------------+-----+------------+-----------+-------------+-------+
1 row in set (0.00 sec)
[root@centos7 mysql]# mysqlbinlog master-log.000002  在文件级别查看
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#170912 19:55:00 server id 1  end_log_pos 245   Start: binlog v 4, server v 5.5.52-MariaDB created 170912 19:55:00
# Warning: this binlog is either in use or was not closed properly.
BINLOG '
FMu3WQ8BAAAA8QAAAPUAAAABAAQANS41LjUyLU1hcmlhREIAbG9nAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAA2QAEGggAAAAICAgCAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAeBDn0A==
'/*!*/;
# at 245
#170912 19:55:06 server id 1  end_log_pos 313   Query   thread_id=2 exec_time=0 error_code=0
SET TIMESTAMP=1505217306/*!*/;
SET @@session.pseudo_thread_id=2/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
BEGIN
/*!*/;
# at 313
#170912 19:55:06 server id 1  end_log_pos 413   Query   thread_id=2 exec_time=0 error_code=0
use `mydb`/*!*/;
SET TIMESTAMP=1505217306/*!*/;
delete from students where stuid=1987
/*!*/;
# at 413
#170912 19:55:06 server id 1  end_log_pos 440   Xid = 32
COMMIT/*!*/;
# at 440
#170912 20:24:56 server id 1  end_log_pos 508   Query   thread_id=2 exec_time=0 error_code=0
SET TIMESTAMP=1505219096/*!*/;
BEGIN
/*!*/;
# at 508
#170912 20:24:56 server id 1  end_log_pos 608   Query   thread_id=2 exec_time=0 error_code=0
SET TIMESTAMP=1505219096/*!*/;
delete from students where stuid=1957
/*!*/;
# at 608
#170912 20:24:56 server id 1  end_log_pos 635   Xid = 44
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;

二进制日志事件格式：
                # at 553
                #160831  9:56:08 server id 1  end_log_pos 624   Query   thread_id=2     exec_time=0     error_code=0
                SET TIMESTAMP=1472608568/*!*/;
                BEGIN
                /*!*/;
                
                事件的起始位置：# at 553
                事件发生的日期时间：#160831  9:56:08
                事件发生的服务器id：server id 1
                事件的结束位置：end_log_pos 624
                事件的类型：Query
                事件发生时所在服务器执行此事件的线程的ID： thread_id=2 
                语句的时间戳与将其写入二进制日志文件中的时间差：exec_time=0
                错误代码：error_code=0
                设定事件发生时的时间戳：SET TIMESTAMP=1472608568/*!*/;
                事件内容：BEGIN

[root@centos7 mysql]# mysqlbinlog --start-position=440 master-log.000002   表示从440以后显示
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#170912 19:55:00 server id 1  end_log_pos 245   Start: binlog v 4, server v 5.5.52-MariaDB created 1
70912 19:55:00# Warning: this binlog is either in use or was not closed properly.
BINLOG '
FMu3WQ8BAAAA8QAAAPUAAAABAAQANS41LjUyLU1hcmlhREIAbG9nAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAA2QAEGggAAAAICAgCAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAeBDn0A==
'/*!*/;
# at 440
#170912 20:24:56 server id 1  end_log_pos 508   Query   thread_id=2 exec_time=0 error_code=0
SET TIMESTAMP=1505219096/*!*/;
SET @@session.pseudo_thread_id=2/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@sessi
on.autocommit=1/*!*/;SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8
/*!*/;SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
BEGIN
/*!*/;
# at 508
#170912 20:24:56 server id 1  end_log_pos 608   Query   thread_id=2 exec_time=0 error_code=0
use `mydb`/*!*/;
SET TIMESTAMP=1505219096/*!*/;
delete from students where stuid=1957
/*!*/;
# at 608
#170912 20:24:56 server id 1  end_log_pos 635   Xid = 44
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;

[root@centos7 mysql]# mysqlbinlog --start-position=440 --stop-position=508 master-log.000002   表示查看440-508这一段的数据
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#170912 19:55:00 server id 1  end_log_pos 245   Start: binlog v 4, server v 5.5.52-MariaDB created 1
70912 19:55:00# Warning: this binlog is either in use or was not closed properly.
BINLOG '
FMu3WQ8BAAAA8QAAAPUAAAABAAQANS41LjUyLU1hcmlhREIAbG9nAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAA2QAEGggAAAAICAgCAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAeBDn0A==
'/*!*/;
# at 440
#170912 20:24:56 server id 1  end_log_pos 508   Query   thread_id=2 exec_time=0 error_code=0
SET TIMESTAMP=1505219096/*!*/;
SET @@session.pseudo_thread_id=2/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@sessi
on.autocommit=1/*!*/;SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8
/*!*/;SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
BEGIN
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;

最后编辑于：2017.12.10 07:53:38

人面猴
序言：七十年代末，一起剥皮案震惊了整个滨河市，随后出现的几起案子，更是在滨河造成了极大的恐慌，老刑警刘岩，带你破解...
沈念sama阅读 158,233评论 4赞 360
死咒
序言：滨河连续发生了三起死亡事件，死亡现场离奇诡异，居然都是意外死亡，警方通过查阅死者的电脑和手机，发现死者居然都...
沈念sama阅读 67,013评论 1赞 291
救了他两次的神仙让他今天三更去死
文/潘晓璐我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
开封第一讲书人阅读 108,030评论 0赞 241
道士缉凶录：失踪的卖姜人
文/不坏的土叔我叫张陵，是天一观的道长。经常有香客问我，道长，这世上最难降的妖魔是什么？我笑而不...
开封第一讲书人阅读 43,827评论 0赞 204
港岛之恋（遗憾婚礼）
正文为了忘掉前任，我火速办了婚礼，结果婚礼上，老公的妹妹穿的比我还像新娘。我一直安慰自己，他们只是感情好，可当我...
茶点故事阅读 52,221评论 3赞 286
恶毒庶女顶嫁案：这布局不是一般人想出来的
文/花漫我一把揭开白布。她就那样静静地躺着，像睡着了一般。火红的嫁衣衬着肌肤如雪。梳的纹丝不乱的头发上，一...
开封第一讲书人阅读 40,542评论 1赞 216
城市分裂传说
那天，我揣着相机与录音，去河边找鬼。笑死，一个胖子当着我的面吹牛，可吹牛的内容都是我干的。我是一名探鬼主播，决...
沈念sama阅读 31,814评论 2赞 312
双鸳鸯连环套：你想象不到人心有多黑
文/苍兰香墨我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
开封第一讲书人阅读 30,513评论 0赞 198
万荣杀人案实录
序言：老挝万荣一对情侣失踪，失踪者是张志新（化名）和其女友刘颖，没想到半个月后，有当地人在树林里发现了一具尸体，经...
沈念sama阅读 34,225评论 1赞 241
护林员之死
正文独居荒郊野岭守林人离奇死亡，尸身上长有42处带血的脓包…… 初始之章·张勋以下内容为张勋视角年9月15日...
茶点故事阅读 30,497评论 2赞 244
白月光启示录
正文我和宋清朗相恋三年，在试婚纱的时候发现自己被绿了。大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
茶点故事阅读 31,998评论 1赞 258
活死人
序言：一个原本活蹦乱跳的男人离奇死亡，死状恐怖，灵堂内的尸体忽然破棺而出，到底是诈尸还是另有隐情，我是刑警宁泽，带...
沈念sama阅读 28,342评论 2赞 253
日本核电站爆炸内幕
正文年R本政府宣布，位于F岛的核电站，受9级特大地震影响，放射性物质发生泄漏。R本人自食恶果不足惜，却给世界环境...
茶点故事阅读 32,986评论 3赞 235
男人毒药：我在死后第九天来索命
文/蒙蒙一、第九天我趴在偏房一处隐蔽的房顶上张望。院中可真热闹，春花似锦、人声如沸。这庄子的主人今日做“春日...
开封第一讲书人阅读 26,055评论 0赞 8
一桩弑父案，背后竟有这般阴谋
文/苍兰香墨我抬头看了看天上的太阳。三九已至，却和暖如春，着一层夹袄步出监牢的瞬间，已是汗流浃背。一阵脚步声响...
开封第一讲书人阅读 26,812评论 0赞 194
情欲美人皮
我被黑心中介骗来泰国打工，没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留，地道东北人。一个月前我还...
沈念sama阅读 35,560评论 2赞 271
代替公主和亲
正文我出身青楼，却偏偏与公主长得像，于是被迫代替她去往敌国和亲。传闻我的和亲对象是个残疾皇子，可洞房花烛夜当晚...
茶点故事阅读 35,461评论 2赞 266

mysql 的日志

推荐阅读更多精彩内容