首先造一些数据出来,如下:
mysql> create database fafa;
Query OK, 1 row affected (0.01 sec)
mysql> use fafa
Database changed
mysql> create table test(jj int,kk varchar(10));
Query OK, 0 rows affected (0.02 sec)
接下来我们在主库循环插入数据实验,然后看看进程状态,和同步情况
创建procedure
delimiter //
create procedure fafa()
begin
declare num int;
set num=1;
while num < 8000000 do
insert into test(jj,kk) values(num,'fafa');
set num=num+1;