mysql> update tbrepl set name='abc' limit 2; Query OK, 2 rows affected (0.01 sec) Rows matched: 2 Changed: 2 Warnings: 0 mysql> select * from tbrepl; +------+------+ | i | name | +------+------+ | 1 | abc | | 1 | abc | | 2 | NULL | | 1 | NULL | +------+------+ 4 rows in set (0.01 sec) mysql> select * from mysql.ndb_binlog_index; +----------+------------+---------------+---------+---------+---------+-----------+----------------+------------+-----+---------------+------------+ | Position | File | epoch | inserts | updates | deletes | schemaops | orig_server_id | orig_epoch | gci | next_position | next_file | +----------+------------+---------------+---------+---------+---------+-----------+----------------+------------+-----+---------------+------------+ | 479 | ./1.000001 | 1108101562371 | 1 | 0 | 0 | 0 | 0 | 0 | 258 | 814 | ./1.000001 | | 814 | ./1.000001 | 1112396529666 | 1 | 0 | 0 | 0 | 0 | 0 | 259 | 1149 | ./1.000001 | | 1149 | ./1.000001 | 1112396529672 | 1 | 0 | 0 | 0 | 0 | 0 | 259 | 1484 | ./1.000001 | | 1484 | ./1.000001 | 1112396529677 | 1 | 0 | 0 | 0 | 0 | 0 | 259 | 1819 | ./1.000001 | | 1819 | ./1.000001 | 1163936137218 | 0 | 1 | 0 | 0 | 0 | 0 | 271 | 2160 | ./1.000001 | | 2272 | ./1.000001 | 1524713390095 | 0 | 2 | 0 | 0 | 0 | 0 | 355 | 2634 | ./1.000001 | +----------+------------+---------------+---------+---------+---------+-----------+----------------+------------+-----+---------------+------------+ 6 rows in set (0.00 sec) mysql> create table tbrep3(i int(10)); Query OK, 0 rows affected (0.41 sec) mysql> select * from mysql.ndb_binlog_index; +----------+------------+---------------+---------+---------+---------+-----------+----------------+------------+-----+---------------+------------+ | Position | File | epoch | inserts | updates | deletes | schemaops | orig_server_id | orig_epoch | gci | next_position | next_file | +----------+------------+---------------+---------+---------+---------+-----------+----------------+------------+-----+---------------+------------+ | 479 | ./1.000001 | 1108101562371 | 1 | 0 | 0 | 0 | 0 | 0 | 258 | 814 | ./1.000001 | | 814 | ./1.000001 | 1112396529666 | 1 | 0 | 0 | 0 | 0 | 0 | 259 | 1149 | ./1.000001 | | 1149 | ./1.000001 | 1112396529672 | 1 | 0 | 0 | 0 | 0 | 0 | 259 | 1484 | ./1.000001 | | 1484 | ./1.000001 | 1112396529677 | 1 | 0 | 0 | 0 | 0 | 0 | 259 | 1819 | ./1.000001 | | 1819 | ./1.000001 | 1163936137218 | 0 | 1 | 0 | 0 | 0 | 0 | 271 | 2160 | ./1.000001 | | 2272 | ./1.000001 | 1524713390095 | 0 | 2 | 0 | 0 | 0 | 0 | 355 | 2634 | ./1.000001 | +----------+------------+---------------+---------+---------+---------+-----------+----------------+------------+-----+---------------+------------+ 6 rows in set (0.00 sec) mysql> insert into tbrep3 values(1); Query OK, 1 row affected (0.01 sec) mysql> select * from mysql.ndb_binlog_index; +----------+------------+---------------+---------+---------+---------+-----------+----------------+------------+-----+---------------+------------+ | Position | File | epoch | inserts | updates | deletes | schemaops | orig_server_id | orig_epoch | gci | next_position | next_file | +----------+------------+---------------+---------+---------+---------+-----------+----------------+------------+-----+---------------+------------+ | 479 | ./1.000001 | 1108101562371 | 1 | 0 | 0 | 0 | 0 | 0 | 258 | 814 | ./1.000001 | | 814 | ./1.000001 | 1112396529666 | 1 | 0 | 0 | 0 | 0 | 0 | 259 | 1149 | ./1.000001 | | 1149 | ./1.000001 | 1112396529672 | 1 | 0 | 0 | 0 | 0 | 0 | 259 | 1484 | ./1.000001 | | 1484 | ./1.000001 | 1112396529677 | 1 | 0 | 0 | 0 | 0 | 0 | 259 | 1819 | ./1.000001 | | 1819 | ./1.000001 | 1163936137218 | 0 | 1 | 0 | 0 | 0 | 0 | 271 | 2160 | ./1.000001 | | 2272 | ./1.000001 | 1524713390095 | 0 | 2 | 0 | 0 | 0 | 0 | 355 | 2634 | ./1.000001 | | 2729 | ./1.000001 | 1838246002701 | 1 | 0 | 0 | 0 | 0 | 0 | 428 | 3064 | ./1.000001 | +----------+------------+---------------+---------+---------+---------+-----------+----------------+------------+-----+---------------+------------+ 7 rows in set (0.00 sec) mysql> alter table tbrep3 add column(name varchar(10)); Query OK, 1 row affected (1.00 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> select * from mysql.ndb_binlog_index; +----------+------------+---------------+---------+---------+---------+-----------+----------------+------------+-----+---------------+------------+ | Position | File | epoch | inserts | updates | deletes | schemaops | orig_server_id | orig_epoch | gci | next_position | next_file | +----------+------------+---------------+---------+---------+---------+-----------+----------------+------------+-----+---------------+------------+ | 479 | ./1.000001 | 1108101562371 | 1 | 0 | 0 | 0 | 0 | 0 | 258 | 814 | ./1.000001 | | 814 | ./1.000001 | 1112396529666 | 1 | 0 | 0 | 0 | 0 | 0 | 259 | 1149 | ./1.000001 | | 1149 | ./1.000001 | 1112396529672 | 1 | 0 | 0 | 0 | 0 | 0 | 259 | 1484 | ./1.000001 | | 1484 | ./1.000001 | 1112396529677 | 1 | 0 | 0 | 0 | 0 | 0 | 259 | 1819 | ./1.000001 | | 1819 | ./1.000001 | 1163936137218 | 0 | 1 | 0 | 0 | 0 | 0 | 271 | 2160 | ./1.000001 | | 2272 | ./1.000001 | 1524713390095 | 0 | 2 | 0 | 0 | 0 | 0 | 355 | 2634 | ./1.000001 | | 2729 | ./1.000001 | 1838246002701 | 1 | 0 | 0 | 0 | 0 | 0 | 428 | 3064 | ./1.000001 | +----------+------------+---------------+---------+---------+---------+-----------+----------------+------------+-----+---------------+------------+ 7 rows in set (0.00 sec) mysql>