ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > MySQL > mysql日志

mysql日志

原创 MySQL 作者：oraclesuperman 时间：2015-07-23 17:23:38 0 删除 编辑

2015-07-23 15:59:37 3013 [Note] Binlog end
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'partition'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'BLACKHOLE'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'ARCHIVE'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_METRICS'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_CMP'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'INNODB_TRX'
2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'InnoDB'
2015-07-23 15:59:37 3013 [Note] InnoDB: FTS optimize thread exiting.
2015-07-23 15:59:37 3013 [Note] InnoDB: Starting shutdown...
2015-07-23 15:59:39 3013 [Note] InnoDB: Shutdown completed; log sequence number 375789760
2015-07-23 15:59:39 3013 [Note] Shutting down plugin 'CSV'
2015-07-23 15:59:39 3013 [Note] Shutting down plugin 'MEMORY'
2015-07-23 15:59:39 3013 [Note] Shutting down plugin 'MRG_MYISAM'
2015-07-23 15:59:39 3013 [Note] Shutting down plugin 'MyISAM'
2015-07-23 15:59:39 3013 [Note] Shutting down plugin 'sha256_password'
2015-07-23 15:59:39 3013 [Note] Shutting down plugin 'mysql_old_password'
2015-07-23 15:59:39 3013 [Note] Shutting down plugin 'mysql_native_password'
2015-07-23 15:59:39 3013 [Note] Shutting down plugin 'binlog'
2015-07-23 15:59:39 3013 [Note] /usr/sbin/mysqld: Shutdown complete

150723 15:59:39 mysqld_safe mysqld from pid file /var/lib/mysql/dba.fei.com.pid ended
150723 15:59:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-07-23 15:59:40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server

option (see documentation for more details).
2015-07-23 15:59:40 4066 [Note] Plugin 'FEDERATED' is disabled.
2015-07-23 15:59:40 4066 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-07-23 15:59:40 4066 [Note] InnoDB: The InnoDB memory heap is disabled
2015-07-23 15:59:40 4066 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-07-23 15:59:40 4066 [Note] InnoDB: Memory barrier is not used
2015-07-23 15:59:40 4066 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-07-23 15:59:40 4066 [Note] InnoDB: Using Linux native AIO
2015-07-23 15:59:40 4066 [Note] InnoDB: Not using CPU crc32 instructions
2015-07-23 15:59:40 4066 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-07-23 15:59:40 4066 [Note] InnoDB: Completed initialization of buffer pool
2015-07-23 15:59:40 4066 [Note] InnoDB: Highest supported file format is Barracuda.
2015-07-23 15:59:40 4066 [Note] InnoDB: 128 rollback segment(s) are active.
2015-07-23 15:59:40 4066 [Note] InnoDB: Waiting for purge to start
2015-07-23 15:59:40 4066 [Note] InnoDB: 5.6.23 started; log sequence number 375789760
2015-07-23 15:59:40 4066 [Note] Server hostname (bind-address): '*'; port: 3306
2015-07-23 15:59:40 4066 [Note] IPv6 is available.
2015-07-23 15:59:40 4066 [Note]   - '::' resolves to '::';
2015-07-23 15:59:40 4066 [Note] Server socket created on IP: '::'.
2015-07-23 15:59:40 4066 [Note] Event Scheduler: Loaded 0 events
2015-07-23 15:59:40 4066 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.23'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)

[root@dba mysql]# mysqlbinlog feige-bin.000001
/*!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
#150723 16:48:10 server id 1  end_log_pos 120 CRC32 0x255c1c8e  Start: binlog v 4, server v 5.6.23-log created 150723 16:48:10 at startup
# Warning: this binlog is either in use or was not closed properly.
ROLLBACK/*!*/;
BINLOG '
SqqwVQ8BAAAAdAAAAHgAAAABAAQANS42LjIzLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAABKqrBVEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAY4c
XCU=
'/*!*/;
# at 120
#150723 16:48:55 server id 1  end_log_pos 218 CRC32 0xf09f2560  Query thread_id=1 exec_time=0 error_code=0
use `test`/*!*/;
SET TIMESTAMP=1437641335/*!*/;
SET @@session.pseudo_thread_id=1/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1075838976/*!*/;
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=33/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
DELETE FROM `test`.`tab_memory`
/*!*/;
# at 218
#150723 16:49:11 server id 1  end_log_pos 297 CRC32 0xdc9563bd  Query thread_id=1 exec_time=0 error_code=0
SET TIMESTAMP=1437641351/*!*/;
BEGIN
/*!*/;
# at 297
#150723 16:49:11 server id 1  end_log_pos 401 CRC32 0x8513b5af  Query thread_id=1 exec_time=0 error_code=0
SET TIMESTAMP=1437641351/*!*/;
insert into t values(10,'ccc')
/*!*/;
# at 401
#150723 16:49:11 server id 1  end_log_pos 432 CRC32 0xb54e78d7  Xid = 37
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@dba ~]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#skip-grant-tables
character_set_server=utf8
#character_set_server=gbk
#autocommit=off
log-bin=/var/lib/mysql/feige-bin
#binlog_format=STATEMENT
binlog_format=MIXED


mysql> insert into t values(11,'ccd');
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: test

Query OK, 1 row affected (0.04 sec)

mysql> insert into t values(12,'cce');
Query OK, 1 row affected (0.00 sec)

[root@dba mysql]# mysqlbinlog feige-bin.000003 | grep inse
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
insert into t values(11,'ccd')
insert into t values(12,'cce')
[root@dba ~]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#skip-grant-tables
character_set_server=utf8
#character_set_server=gbk
#autocommit=off
log-bin=/var/lib/mysql/feige-bin
#binlog_format=STATEMENT
#binlog_format=MIXED
binlog_format=ROW


mysql> insert into t values(13,'ccf');
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: test

Query OK, 1 row affected (0.04 sec)


[root@dba mysql]# mysqlbinlog -v feige-bin.000004
/*!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
#150723 17:13:32 server id 1  end_log_pos 120 CRC32 0x65dced15  Start: binlog v 4, server v 5.6.23-log created 150723 17:13:32 at startup
# Warning: this binlog is either in use or was not closed properly.
ROLLBACK/*!*/;
BINLOG '
PLCwVQ8BAAAAdAAAAHgAAAABAAQANS42LjIzLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAA8sLBVEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAARXt
3GU=
'/*!*/;
# at 120
#150723 17:13:46 server id 1  end_log_pos 218 CRC32 0xd08129c1  Query thread_id=1 exec_time=0 error_code=0
use `test`/*!*/;
SET TIMESTAMP=1437642826/*!*/;
SET @@session.pseudo_thread_id=1/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1075838976/*!*/;
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=33/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
DELETE FROM `test`.`tab_memory`
/*!*/;
# at 218
#150723 17:13:46 server id 1  end_log_pos 290 CRC32 0x641cb980  Query thread_id=1 exec_time=0 error_code=0
SET TIMESTAMP=1437642826/*!*/;
BEGIN
/*!*/;
# at 290
#150723 17:13:46 server id 1  end_log_pos 337 CRC32 0xfa0db6cf  Table_map: `test`.`t` mapped to number 86
# at 337
#150723 17:13:46 server id 1  end_log_pos 381 CRC32 0xd0d625b5  Write_rows: table id 86 flags: STMT_END_F

BINLOG '
SrCwVRMBAAAALwAAAFEBAAAAAFYAAAAAAAEABHRlc3QAAXQAAgMPApYAAs+2Dfo=
SrCwVR4BAAAALAAAAH0BAAAAAFYAAAAAAAEAAgAC//wNAAAAA2NjZrUl1tA=
'/*!*/;
### INSERT INTO `test`.`t`
### SET
###   @1=13
###   @2='ccf'
# at 381
#150723 17:13:46 server id 1  end_log_pos 412 CRC32 0x859ef1e7  Xid = 36
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;



来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29313086/viewspace-1745987/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： mysql锁问题的研究
下一篇： CentOS6.4+MySQL-5.6.12 安装详解
请登录后发表评论 登录
全部评论
oraclesuperman

注册时间：2015-03-20

  • 博文量
    178
  • 访问量
    422831

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593