1
# Copyright (C) 2008 Sun Microsystems, Inc. All rights reserved. Use
2
# is subject to license terms.
4
# This program is free software; you can redistribute it and/or modify
5
# it under the terms of the GNU General Public License as published by
6
# the Free Software Foundation; version 2 of the License.
8
# This program is distributed in the hope that it will be useful, but
9
# WITHOUT ANY WARRANTY; without even the implied warranty of
10
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
11
# General Public License for more details.
13
# You should have received a copy of the GNU General Public License
14
# along with this program; if not, write to the Free Software
15
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
18
# Configuration file template for util/simplify-mysqltest.pl
21
# - copy this file to for example simplify-mysqltest_1.cfg and
22
# - adjust the settings so that they fit to your usage case and
30
# Directory where your MySQL release is installed.
32
# If you want to simplify based on result differences between two server versions
33
# instead of looking for expected output from a single server, specify both
34
# basedir and basedir2 below.
36
# Unless you are looking for an assertion, use a non-debug build for faster processing
39
basedir => '/build/bzr/mysql-5.1-rep+3',
43
# File which should be used as the base for the simplification process.
45
# - script (extension .test) for processing via mysq-ltest-run.pl
46
# - statement log (extension .CSV)
47
# Example: <basedir>/var/master-data/mysql/general_log.CSV
50
input_file => '/tmp/general_log.CSV',
54
# Pattern which needs to occur within the MTR output after a successful
55
# simplification. The search pattern is usually derived from a backtrace.
56
# Not needed if two basedirs (servers) are specified (file comparison is used
60
# "." matches any character including newline (the search command uses the "s" modifier)
61
# "{<min>,<max>}" Minimum match count <min> , Maximum match count <max>
62
# So the example pattern causes basically a search for
63
# "safe_cond_timedwait" with a distance of less than 151 characters to a following
64
# "thr_mutex.c" with a distance of less than 51 characters to a following ...
66
# 'safe_cond_timedwait.{0,150}thr_mutex\.c.{0,50}Item_func_sleep::val_int.{0,3000}SELECT 1,SLEEP\(10\)',
69
expected_mtr_output => 'HA_ERR_END_OF_FILE',
71
# Please be careful when using addresses or source file line numbers in search patterns.
72
# - They increase the selectivity of the search.
73
# - A minor change of the server startup options, source files etc. could cause that the search fails.
77
# The header is prepended to each test case and is not influenced by simplification.
78
# If replication is enabled, --source include/master-slave.inc will also be used.
82
# '--source include/master-slave.inc', # Enable this for replication
83
'--disable_abort_on_error',
85
'--disable_query_log',
86
'--disable_result_log'
91
# The footer is appended to each test case and is not influenced by simplification.
92
# When replication is enabled, the default footer is '--sync_slave_with_master'
93
# If you are simplifying a crashing bug, you can also put your crashing query here
97
# '--connection master',
98
# '--sync_slave_with_master', # Enable this for replication
100
# '--let $diff_table_1 = master:test.table1_int',
101
# '--let $diff_table_2 = slave:test.table1_int',
102
# '--source include/diff_tables.inc',
107
# The filter is applied to the test case in order to remove irrelevant queries. If
108
# you are running a replication test, you may also wish to filter out SELECTs
111
filter => qr{SHOW WARNINGS|EXPLAIN}sio,
115
# mysql-test-run.pl (MTR) options which should be used.
116
# 'record' is required if two basedirs (servers) are specified.
120
'skip-ndbcluster' => undef,
123
'no-check-testcases' => undef,
124
'nowarnings' => undef,
130
# MySQL server startup options.
136
# 'binlog-format' => 'mixed',
137
# 'plugin-dir' => '/build/bzr/mysql-5.1-rep+3/plugin/semisync/.libs',
138
# 'plugin-load' => 'rpl_semi_sync_master=libsemisync_master.so:rpl_semi_sync_slave=libsemisync_slave.so',
139
# 'rpl_semi_sync_master_enabled' => 1,
140
# 'rpl_semi_sync_slave_enabled' => 1,
142
# Those options make test execution faster
144
'loose-innodb-fast-shutdown' => 2,
145
'loose-sync-sys' => 0,
146
'loose-lock-wait-timeout' => 1,
147
'loose-rpl_semi_sync_master_timeout' => 10,
148
'log-output' => 'none',
149
'innodb_flush_log_at_trx_commit' => 0,
150
'log-slave-updates' => 0,
153
# Multithreaded test cases
154
#-------------------------
156
# Enabling this option will use --connection --connect and --disconnect
157
# when converting the CSV file into a .test case. This however may cause
158
# considerable slow-down in the simplification process because MTR will
159
# constantly complain about mismatched --connection and --connect in the
160
# intermediate test cases.
added
removed
tests/randgen/simplify-mysqltest_template.cfg
