| 1 |
create table t1 (a int not null, b int not null) engine=innodb; |
| 2 |
insert t1 values (1,2),(3,4); |
| 3 |
lock table t1 write, t1 tr read; |
| 4 |
flush status; |
| 5 |
alter table t1 add primary key (b); |
| 6 |
show status like 'Handler_read_rnd_next'; |
| 7 |
Variable_name Value |
| 8 |
Handler_read_rnd_next 0 |
| 9 |
unlock tables; |
| 10 |
alter table t1 drop primary key; |
| 11 |
lock table t1 write; |
| 12 |
flush status; |
| 13 |
alter table t1 add primary key (b); |
| 14 |
show status like 'Handler_read_rnd_next'; |
| 15 |
Variable_name Value |
| 16 |
Handler_read_rnd_next 0 |
| 17 |
unlock tables; |
| 18 |
alter table t1 drop primary key; |
| 19 |
flush status; |
| 20 |
alter table t1 add primary key (b); |
| 21 |
show status like 'Handler_read_rnd_next'; |
| 22 |
Variable_name Value |
| 23 |
Handler_read_rnd_next 0 |
| 24 |
drop table t1; |