65 lines
2.4 KiB
Plaintext
65 lines
2.4 KiB
Plaintext
--source include/have_ndb.inc
|
|
--source include/not_windows.inc
|
|
--source suite/ndb/include/backup_restore_setup.inc
|
|
|
|
use test;
|
|
|
|
--echo Create a table with some heavy indexing
|
|
|
|
|
|
create table t1 (a int primary key, b int, c varchar(100), d int,
|
|
key (a,b,c,d),
|
|
key (b,a),
|
|
key (b,c),
|
|
key (b,d),
|
|
key (c,a),
|
|
key (c,d),
|
|
key (d,c,b,a),
|
|
key (c,b,a),
|
|
key (c,b,a,d),
|
|
key (b,a,d,c),
|
|
key (a,d,c,b))
|
|
engine = ndb;
|
|
|
|
--echo Insert some rows
|
|
--disable_query_log
|
|
--disable_result_log
|
|
insert into test.t1 values (1,1,repeat('sh', 50), 1);
|
|
insert into test.t1 select a+1, b+1, c, d+1 from test.t1;
|
|
insert into test.t1 select a+2, b+2, c, d+2 from test.t1;
|
|
insert into test.t1 select a+4, b+4, c, d+4 from test.t1;
|
|
insert into test.t1 select a+8, b+8, c, d+8 from test.t1;
|
|
insert into test.t1 select a+16, b+16, c, d+16 from test.t1;
|
|
insert into test.t1 select a+32, b+32, c, d+32 from test.t1;
|
|
insert into test.t1 select a+64, b+64, c, d+64 from test.t1;
|
|
insert into test.t1 select a+128, b+128, c, d+128 from test.t1;
|
|
insert into test.t1 select a+256, b+256, c, d+256 from test.t1;
|
|
insert into test.t1 select a+512, b+512, c, d+512 from test.t1;
|
|
insert into test.t1 select a+1024, b+1024, c, d+1024 from test.t1;
|
|
insert into test.t1 select a+2048, b+2048, c, d+2048 from test.t1;
|
|
insert into test.t1 select a+4096, b+4096, c, d+4096 from test.t1;
|
|
insert into test.t1 select a+8192, b+8192, c, d+8192 from test.t1 limit 8000;
|
|
insert into test.t1 select a+16384, b+16384, c, d+16384 from test.t1 limit 8000;
|
|
insert into test.t1 select a+32768, b+32768, c, d+32768 from test.t1 limit 8000;
|
|
insert into test.t1 select a+65536, b+65536, c, d+65536 from test.t1 limit 8000;
|
|
insert into test.t1 select a+131072, b+131072, c, d+131072 from test.t1 limit 8000;
|
|
|
|
--enable_query_log
|
|
--enable_result_log
|
|
|
|
select count(1) from test.t1;
|
|
|
|
--echo Generate a backup
|
|
--source include/ndb_backup.inc
|
|
|
|
drop table test.t1;
|
|
|
|
--echo Restore with offline (parallel) rebuild
|
|
--exec $NDB_RESTORE -b $the_backup_id -n 1 -m --disable-indexes -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
|
|
--exec $NDB_RESTORE -b $the_backup_id -n 2 --disable_indexes -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
|
|
--exec $NDB_RESTORE -b $the_backup_id -n 1 --rebuild-indexes $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
|
|
|
|
drop table test.t1;
|
|
--source suite/ndb/include/backup_restore_cleanup.inc
|
|
--remove_file $NDB_TOOLS_OUTPUT
|