-- 5.7.20 rm -rf 88788 bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/88788 bin/mysqld --no-defaults --log-bin=servername.dmz.corp.de_binlog --server_id=42 --basedir=$PWD --datadir=$PWD/88788 --core-file --socket=/tmp/mysql_ushastry.sock --port=3307 --log-error=$PWD/88788/log.err 2>&1 & [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.20-log MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show variables like 'log_bin%'; +---------------------------------+----------------------------------------------------------------------------+ | Variable_name | Value | +---------------------------------+----------------------------------------------------------------------------+ | log_bin | ON | | log_bin_basename | /export/umesh/server/binaries/GABuilds/mysql-5.7.20/88788/servername | | log_bin_index | /export/umesh/server/binaries/GABuilds/mysql-5.7.20/88788/servername.index | | log_bin_trust_function_creators | OFF | | log_bin_use_v1_row_events | OFF | +---------------------------------+----------------------------------------------------------------------------+ 5 rows in set (0.00 sec) mysql> show master status; +---------------------+----------+--------------+------------------+-------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +---------------------+----------+--------------+------------------+-------------------+ | servername.dmz.corp | 154 | | | | +---------------------+----------+--------------+------------------+-------------------+ 1 row in set (0.00 sec) mysql> create database db1; Query OK, 1 row affected (0.00 sec) mysql> create table db1.t1(id int not null); Query OK, 0 rows affected (0.00 sec) mysql> show master status; +---------------------+----------+--------------+------------------+-------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +---------------------+----------+--------------+------------------+-------------------+ | servername.dmz.corp | 480 | | | | +---------------------+----------+--------------+------------------+-------------------+ 1 row in set (0.00 sec) mysql> show binary logs; +---------------------+-----------+ | Log_name | File_size | +---------------------+-----------+ | servername.dmz.corp | 480 | | servername.dmz.corp | 480 | +---------------------+-----------+ 2 rows in set (0.00 sec) mysql> flush binary logs; Query OK, 0 rows affected (0.00 sec) mysql> show binary logs; +---------------------+-----------+ | Log_name | File_size | +---------------------+-----------+ | servername.dmz.corp | 154 | | servername.dmz.corp | 154 | | servername.dmz.corp | 154 | +---------------------+-----------+ 3 rows in set (0.00 sec) mysql> system ls -l 88788/servername.* -rw-r----- 1 umshastr common 530 Dec 7 10:52 88788/servername.dmz.corp -rw-r----- 1 umshastr common 66 Dec 7 10:52 88788/servername.index mysql> mysql> system cat 88788/servername.index ./servername.dmz.corp ./servername.dmz.corp ./servername.dmz.corp -- DDL/DML mysql> CREATE TABLE `keyvalue` ( -> `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, -> `name1` varchar(250), -> `name2` varchar(250), -> `name3` varchar(250), -> `name4` varchar(250), -> PRIMARY KEY (`id`, name1(10)) -> ) ENGINE=innodb; Query OK, 0 rows affected (0.00 sec) mysql> mysql> set @id:=0; Query OK, 0 rows affected (0.00 sec) mysql> mysql> insert into `keyvalue` values -> (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)) -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)) -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)) -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)); Query OK, 4 rows affected (0.00 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql> mysql> insert into `keyvalue`(`id`,`name1`,`name2`,`name3`,`name4`) -> select @id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000) from -> `keyvalue` k1, `keyvalue` k2, `keyvalue` k3, `keyvalue` k4,`keyvalue` k5,`keyvalue` k6, `keyvalue` k7, `keyvalue` k8, `keyvalue` k9, -> `keyvalue` k0,`keyvalue` ka, `keyvalue` kb, `keyvalue` kc, `keyvalue` kd limit 9000000; Query OK, 9000000 rows affected (3 min 29.75 sec) Records: 9000000 Duplicates: 0 Warnings: 0 mysql> flush binary logs; Query OK, 0 rows affected (0.00 sec) mysql> \q Bye [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: bin/mysqlbinlog 88788/servername.dmz.corp | grep -i -e warn -e err ERROR: Error in Log_event::read_log_event(): 'read error', data_len: 3093823488, event_type: 0 # Warning: this binlog is either in use or was not closed properly.