Debian Codegraph @

mysql-test/suite/innodb/t/innodb_bulk_create_index.test

raw
1 ######## suite/innodb/t/innodb_bulk_create_index.test #####
2 # #
3 # Testcase for worklog WL#7277: Bulk Load for Create Index #
4 # The basic idea of bulk load is to build an index from bottom up #
5 # (also known as sorted index build). #
6 # Earlier index was create by repeatedly inserting records #
7 # Test scenario : #
8 # - Run bulk create index on 10K rows #
9 # - Run bulk create index on table with various row types #
10 # - Run DML and SELECT after bulk index creation #
11 # Creation: #
12 # 2014-06-19 Implemented this test as part of WL#7277 #
13 # #
14 ######################################################################
15
16 -- source include/have_innodb_max_16k.inc
17 -- source include/big_test.inc
18
19 # Test Row Format: REDUNDANT.
20 let $row_format = REDUNDANT;
21 -- source suite/innodb/include/innodb_bulk_create_index.inc
22
23 # Test Row Format: COMPACT.
24 let $row_format = COMPACT;
25 -- source suite/innodb/include/innodb_bulk_create_index.inc
26
27 # Test Row Format: DYNAMIC.
28 let $row_format = DYNAMIC;
29 -- source suite/innodb/include/innodb_bulk_create_index.inc
30
31 # Test Row Format: COMPRESSED.
32 let $row_format = COMPRESSED;
33 -- source suite/innodb/include/innodb_bulk_create_index.inc
34
35 # Test Fill Factor: 10
36 let $row_format = COMPACT;
37 SET GLOBAL innodb_fill_factor=10;
38 -- source suite/innodb/include/innodb_bulk_create_index.inc
39
40 # Test Fill Factor: 50
41 let $row_format = COMPACT;
42 SET GLOBAL innodb_fill_factor=50;
43 -- source suite/innodb/include/innodb_bulk_create_index.inc
44
45 SET GLOBAL innodb_fill_factor=default;