1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
|
# Created: 2015-05-15 Lalit Choudhary
-- source include/big_test.inc
--echo #
--echo # WL#7755 mysqlpump: Extend mysqldump functionalities
--echo #
# Creating DB's and populating different types of data init for MYSQLPUMP testing.
-- source include/mysqlpump_stmt.inc
--echo
# parallel-schemas option testing
--exec $MYSQL_PUMP --parallel-schemas=3:db1 > $MYSQLTEST_VARDIR/tmp/output_file_1.sql
--exec $MYSQL_PUMP --parallel-schemas=3:db1,db1_1gb --databases db1 db1_1gb > $MYSQLTEST_VARDIR/tmp/output_file_2.sql
--exec $MYSQL_PUMP --parallel-schemas=3:db1 --parallel-schemas=db2,db3 --include-databases=db1,db2,db3 > $MYSQLTEST_VARDIR/tmp/output_file_3.sql
--exec $MYSQL_PUMP --parallel-schemas=db3 --databases db1 > $MYSQLTEST_VARDIR/tmp/output_file_4.sql
--exec $MYSQL_PUMP --parallel-schemas=1 --databases db2 > $MYSQLTEST_VARDIR/tmp/output_file_5.sql
DROP DATABASE db1;
DROP DATABASE db1_1gb;
--exec $MYSQL < $MYSQLTEST_VARDIR/tmp/output_file_2.sql
--exec $MYSQL_PUMP --parallel-schemas=2:db2,db1 --parallel-schemas=3:db3 --include-databases=db1,db2,db3 > $MYSQLTEST_VARDIR/tmp/output_file_6.sql
--exec $MYSQL_PUMP --parallel-schemas=2:db3,db1 --parallel-schemas=1:db3,db1 --parallel-schemas=2:db3,db1,db1_1gb --include-databases=db1,db1_1gb,db3 > $MYSQLTEST_VARDIR/tmp/output_file_7.sql
--exec $MYSQL_PUMP --default-parallelism=1 --parallel-schemas=db2,db3 --include-databases=db2,db3 > $MYSQLTEST_VARDIR/tmp/output_file_8.sql
--exec $MYSQL_PUMP --default-parallelism=2 --parallel-schemas=4 > $MYSQLTEST_VARDIR/tmp/output_file_10.sql
DROP DATABASE db2;
DROP DATABASE db3;
--exec $MYSQL < $MYSQLTEST_VARDIR/tmp/output_file_8.sql
#--exec $MYSQL_PUMP --parallel-schemas > $MYSQLTEST_VARDIR/tmp/output_file_11.sql
#--exec $MYSQL_PUMP --parallel-schemas= > $MYSQLTEST_VARDIR/tmp/output_file_12.sql
#--exec $MYSQL_PUMP --parallel-schemas=string_edjdjh > $MYSQLTEST_VARDIR/tmp/output_file_13.sql
# chrashing
#--exec $MYSQL_PUMP --parallel-schemas=%&* > $MYSQLTEST_VARDIR/tmp/output_file_14.sql
# default-parallelism option testing
--exec $MYSQL_PUMP --default-parallelism=3 > $MYSQLTEST_VARDIR/tmp/output_file_16.sql
--exec $MYSQL_PUMP --default-parallelism=0 > $MYSQLTEST_VARDIR/tmp/output_file_17.sql
--exec $MYSQL_PUMP --single-transaction > $MYSQLTEST_VARDIR/tmp/output_file_18.sql
--exec $MYSQL_PUMP --default-parallelism=3 --default-parallelism=1 --default-parallelism=2 > $MYSQLTEST_VARDIR/tmp/output_file_19.sql
# mysqlpump: [ERROR] mysqlpump: option '--default-parallelism' requires an argument
#--exec $MYSQL_PUMP --default-parallelism > $MYSQLTEST_VARDIR/tmp/output_file_20.sql
# mysqlpump: [ERROR] mysqlpump: Empty value for 'default-parallelism' specified
#--exec $MYSQL_PUMP --default-parallelism='' > $MYSQLTEST_VARDIR/tmp/output_file_21.sql
#mysqlpump: [ERROR] Unknown suffix 's' used for variable 'default-parallelism' (value 'sgdhy7')
#--exec $MYSQL_PUMP --default-parallelism='sgdhy7' --include-databases=db1 > $MYSQLTEST_VARDIR/tmp/output_file_22.sql
# mysqlpump: [ERROR] mysqlpump: Error while setting value '#@' to 'default-parallelism'
#--exec $MYSQL_PUMP --default-parallelism=#@&%* --include-databases=db1 > $MYSQLTEST_VARDIR/tmp/output_file_23.sql
--remove_files_wildcard $MYSQLTEST_VARDIR/tmp/ output_file*
# --result-file and --watch-progress
--exec $MYSQL_PUMP --parallel-schemas=1:db1 --exclude-databases=mtr,mysql,sys,test --watch-progress 2>$MYSQLTEST_VARDIR/tmp/watch_progress_1.log --result-file=$MYSQLTEST_VARDIR/tmp/result_file_1.sql
--exec $MYSQL_PUMP --parallel-schemas=2:db3 --exclude-databases=mtr,mysql,sys,test --watch-progress 2>$MYSQLTEST_VARDIR/tmp/watch_progress_2.log > $MYSQLTEST_VARDIR/tmp/result_file_2.sql
DROP DATABASE db1;
DROP DATABASE db2;
DROP DATABASE db3;
DROP DATABASE db1_1gb;
--exec $MYSQL < $MYSQLTEST_VARDIR/tmp/result_file_1.sql
DROP DATABASE db1;
DROP DATABASE db2;
DROP DATABASE db3;
DROP DATABASE db1_1gb;
--exec $MYSQL < $MYSQLTEST_VARDIR/tmp/result_file_2.sql
--remove_file $MYSQLTEST_VARDIR/tmp/result_file_1.sql
--remove_file $MYSQLTEST_VARDIR/tmp/result_file_2.sql
# Cleanup
DROP DATABASE db1;
DROP DATABASE db2;
DROP DATABASE db3;
DROP DATABASE db1_1gb;
--remove_file $MYSQLTEST_VARDIR/tmp/watch_progress_1.log
--remove_file $MYSQLTEST_VARDIR/tmp/watch_progress_2.log
|
