# Copyright (C) 2016 MariaDB Corporation. # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; version 2 of the License. # # This program is distributed in the hope that it will be useful, but # WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU # General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 # USA # Rough imitation of OLTP test (sysbench-like) # Default number of tables is 5, 1000 rows each, # it can be changed by providing --rows parameter on the command line $tables = { pk => [ undef ], names => [ 'tab1'], engines => ['InnoDB'], row_formats => ['REDUNDANT',], rows => [ 100 ], }; $fields = { sqls => [ "`pk` int(10) unsigned NOT NULL auto_increment", "`a` varchar(100)", "`b` varchar(100)", "`c` varchar(100)", "`d` varchar(100)", "`e` varchar(100)", "`f` varchar(100)", ], index_sqls => [ "PRIMARY KEY (`pk`)", "KEY `abcdef` (`a`, `b`, `c`, `d`, `e`, `f`)", "KEY `bacdef` (`b`, `a`, `c`, `d`, `e`, `f`)", "KEY `acbdef` (`a`, `c`, `b`, `d`, `e`, `f`)", "KEY `abdcef` (`a`, `b`, `d`, `c`, `e`, `f`)", "KEY `abcedf` (`a`, `b`, `c`, `e`, `d`, `f`)", "KEY `abcdfe` (`a`, `b`, `c`, `d`, `f`, `e`)", "KEY `fbcdea` (`f`, `b`, `c`, `d`, `e`, `a`)", "KEY `fedcba` (`f`, `e`, `d`, `c`, `b`, `a`)", "KEY `fedcab` (`f`, `e`, `d`, `c`, `a`, `b`)", "KEY `fedbca` (`f`, `e`, `d`, `b`, `c`, `a`)", "KEY `fecdba` (`f`, `e`, `c`, `d`, `b`, `a`)", "KEY `fdecba` (`f`, `d`, `e`, `c`, `b`, `a`)", "KEY `efdcba` (`e`, `f`, `d`, `c`, `b`, `a`)", "KEY `aedcbf` (`a`, `e`, `d`, `c`, `b`, `f`)", ], types => [ undef ], indexes => [ undef ], }; $data = { numbers => [ 'digit', 'null', undef ], strings => [ 'letter', 'english', 'char(12)' ], }