// Build commit: f11a63734bfab93fb223d17387ff401572909b38 date: 2015-03-27 18:03:55 +0100 build-date: 2015-03-28 03:30:33 +0100 short: f11a637 branch: mysql-5.6 MySQL source 5.6.25 // 5.6.25 scripts/mysql_install_db --basedir=/export/umesh/mysql-5.6.25 --datadir=/export/umesh/mysql-5.6.25/76370 bin/mysqld --server-id=1 --log_bin=master-bin --basedir=/export/umesh/mysql-5.6.25 --datadir=/export/umesh/mysql-5.6.25/76370 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.6.25/76370/log.err 2>&1 & mysql> use test; Database changed mysql> drop table if exists test; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> create table test(id bigint); Query OK, 0 rows affected (0.01 sec) mysql> set @a=1; Query OK, 0 rows affected (0.00 sec) mysql> insert into test values (@a); Query OK, 1 row affected (0.00 sec) mysql> show binlog events; +-------------------+-----+-------------+-----------+-------------+----------------------------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +-------------------+-----+-------------+-----------+-------------+----------------------------------------------------------------------+ | master-bin.000001 | 4 | Format_desc | 1 | 120 | Server ver: 5.6.25-enterprise-commercial-advanced-log, Binlog ver: 4 | | master-bin.000001 | 120 | Query | 1 | 247 | use `test`; DROP TABLE IF EXISTS `test` /* generated by server */ | | master-bin.000001 | 247 | Query | 1 | 349 | use `test`; create table test(id bigint) | | master-bin.000001 | 349 | Query | 1 | 428 | BEGIN | | master-bin.000001 | 428 | User var | 1 | 475 | @`a`=1 | | master-bin.000001 | 475 | Query | 1 | 577 | use `test`; insert into test values (@a) | | master-bin.000001 | 577 | Xid | 1 | 608 | COMMIT /* xid=11 */ | +-------------------+-----+-------------+-----------+-------------+----------------------------------------------------------------------+ 7 rows in set (0.00 sec) // with --read-from-remote-server [umshastr@hod03]/export/umesh/mysql-5.6.25: bin/mysqlbinlog -uroot -p --read-from-remote-server --host=localhost --port=15000 --protocol=tcp --database=test --to-last-log --stop-never --start-position=1 master-bin.000001 Enter password: Warning: option 'start-position': unsigned value 1 adjusted to 4 /*!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 #700101 1:00:00 server id 1 end_log_pos 0 Rotate to master-bin.000001 pos: 4 # at 4 #150330 14:23:42 server id 1 end_log_pos 120 CRC32 0x2a6a3286 Start: binlog v 4, server v 5.6.25-enterprise-commercial-advanced-log created 150330 14:23:42 at startup ROLLBACK/*!*/; BINLOG ' TkAZVQ8BAAAAdAAAAHgAAAAAAAQANS42LjI1LWVudGVycHJpc2UtY29tbWVyY2lhbC1hZHZhbmNl ZC1sb2cAAAAAAAAAAABOQBlVEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAYYy aio= '/*!*/; # at 120 #150330 14:24:31 server id 1 end_log_pos 247 CRC32 0xd8a29183 Query thread_id=1 exec_time=0 error_code=0 use `test`/*!*/; SET TIMESTAMP=1427718271/*!*/; 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=1073741824/*!*/; 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/*!*/; DROP TABLE IF EXISTS `test` /* generated by server */ /*!*/; # at 247 #150330 14:24:31 server id 1 end_log_pos 349 CRC32 0x12738d77 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1427718271/*!*/; create table test(id bigint) /*!*/; # at 349 #150330 14:24:37 server id 1 end_log_pos 428 CRC32 0xafa00689 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1427718277/*!*/; BEGIN /*!*/; # at 428 # at 475 #150330 14:24:37 server id 1 end_log_pos 475 CRC32 0xda26a366 User_var SET @``:=4611686018444165120/*!*/; #150330 14:24:37 server id 1 end_log_pos 577 CRC32 0x7c9c77f7 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1427718277/*!*/; insert into test values (@a) /*!*/; # at 577 #150330 14:24:37 server id 1 end_log_pos 608 CRC32 0x50357310 Xid = 11 COMMIT/*!*/; // Locally [umshastr@hod03]/export/umesh/mysql-5.6.25: bin/mysqlbinlog --database=test --to-last-log --stop-never --start-position=1 76370/master-bin.000001 Warning: option 'start-position': unsigned value 1 adjusted to 4 /*!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 #150330 14:23:42 server id 1 end_log_pos 120 CRC32 0x2a6a3286 Start: binlog v 4, server v 5.6.25-enterprise-commercial-advanced-log created 150330 14:23:42 at startup # Warning: this binlog is either in use or was not closed properly. ROLLBACK/*!*/; BINLOG ' TkAZVQ8BAAAAdAAAAHgAAAABAAQANS42LjI1LWVudGVycHJpc2UtY29tbWVyY2lhbC1hZHZhbmNl ZC1sb2cAAAAAAAAAAABOQBlVEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAYYy aio= '/*!*/; # at 120 #150330 14:24:31 server id 1 end_log_pos 247 CRC32 0xd8a29183 Query thread_id=1 exec_time=0 error_code=0 use `test`/*!*/; SET TIMESTAMP=1427718271/*!*/; 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=1073741824/*!*/; 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/*!*/; DROP TABLE IF EXISTS `test` /* generated by server */ /*!*/; # at 247 #150330 14:24:31 server id 1 end_log_pos 349 CRC32 0x12738d77 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1427718271/*!*/; create table test(id bigint) /*!*/; # at 349 #150330 14:24:37 server id 1 end_log_pos 428 CRC32 0xafa00689 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1427718277/*!*/; BEGIN /*!*/; # at 428 # at 475 #150330 14:24:37 server id 1 end_log_pos 475 CRC32 0xda26a366 User_var SET @`a`:=1/*!*/; #150330 14:24:37 server id 1 end_log_pos 577 CRC32 0x7c9c77f7 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1427718277/*!*/; insert into test values (@a) /*!*/; # at 577 #150330 14:24:37 server id 1 end_log_pos 608 CRC32 0x50357310 Xid = 11 COMMIT/*!*/; DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; [umshastr@hod03]/export/umesh/mysql-5.6.25: