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: InnoDB: 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/not_embedded.inc
17 -- source include/innodb_page_size_small.inc
18 -- source include/big_test.inc
19
20 # Test Row Format: REDUNDANT.
21 let $row_format = REDUNDANT;
22 -- source suite/innodb/include/innodb_bulk_create_index.inc
23
24 # Test Row Format: COMPACT.
25 let $row_format = COMPACT;
26 -- source suite/innodb/include/innodb_bulk_create_index.inc
27
28 # Test Row Format: DYNAMIC.
29 let $row_format = DYNAMIC;
30 -- source suite/innodb/include/innodb_bulk_create_index.inc
31
32 # Test Row Format: COMPRESSED.
33 let $row_format = COMPRESSED;
34 -- source suite/innodb/include/innodb_bulk_create_index.inc
35
36 # Test Fill Factor: 10
37 let $row_format = COMPACT;
38 SET GLOBAL innodb_fill_factor=10;
39 -- source suite/innodb/include/innodb_bulk_create_index.inc
40
41 # Test Fill Factor: 50
42 let $row_format = COMPACT;
43 SET GLOBAL innodb_fill_factor=50;
44 -- source suite/innodb/include/innodb_bulk_create_index.inc
45
46 SET GLOBAL innodb_fill_factor=default;