1# Copyright (c) 2007, 2013, Oracle and/or its affiliates. All rights reserved.
2#
3# This program is free software; you can redistribute it and/or modify
4# it under the terms of the GNU General Public License, version 2.0,
5# as published by the Free Software Foundation.
6#
7# This program is also distributed with certain software (including
8# but not limited to OpenSSL) that is licensed under separate terms,
9# as designated in a particular file or component or in included license
10# documentation.  The authors of MySQL hereby grant you an additional
11# permission to link the program and your derivative works with the
12# separately licensed software that they have included with MySQL.
13#
14# This program is distributed in the hope that it will be useful,
15# but WITHOUT ANY WARRANTY; without even the implied warranty of
16# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
17# GNU General Public License, version 2.0, for more details.
18#
19# You should have received a copy of the GNU General Public License
20# along with this program; if not, write to the Free Software
21# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301  USA
22
23# Default values that applies to all MySQL Servers
24[mysqld]
25open-files-limit=           1024
26local-infile
27character-set-server=      latin1
28
29# Increase default connect_timeout to avoid intermittent
30# disconnects when test servers are put under load see BUG#28359
31connect-timeout=            60
32
33log-bin-trust-function-creators=1
34key_buffer_size=            1M
35sort_buffer_size=           256K
36max_heap_table_size=        1M
37
38loose-innodb_data_file_path=      ibdata1:10M:autoextend
39loose-innodb_buffer_pool_size=    8M
40loose-innodb_lru_scan_depth=      100
41loose-innodb_write_io_threads=    2
42loose-innodb_read_io_threads=     2
43loose-innodb_log_buffer_size=     1M
44loose-innodb_log_file_size=       5M
45loose-innodb_additional_mem_pool_size= 1M
46loose-innodb_log_files_in_group=  2
47
48slave-net-timeout=120
49
50log-bin=mysqld-bin
51
52# MAINTAINER:
53# the loose- syntax is to make sure the cnf file is also
54# valid when building without the performance schema.
55
56# Run tests with the performance schema instrumentation
57loose-enable-performance-schema
58# Run tests with a small number of instrumented objects
59# to limit memory consumption with MTR
60loose-performance-schema-accounts-size=100
61loose-performance-schema-digests-size=200
62loose-performance-schema-hosts-size=100
63loose-performance-schema-users-size=100
64loose-performance-schema-max-mutex-instances=5000
65loose-performance-schema-max-rwlock-instances=5000
66loose-performance-schema-max-cond-instances=1000
67loose-performance-schema-max-file-instances=10000
68loose-performance-schema-max-socket-instances=1000
69loose-performance-schema-max-table-instances=500
70loose-performance-schema-max-table-handles=1000
71
72loose-performance-schema-events-waits-history-size=10
73loose-performance-schema-events-waits-history-long-size=10000
74loose-performance-schema-events-stages-history-size=10
75loose-performance-schema-events-stages-history-long-size=1000
76loose-performance-schema-events-statements-history-size=10
77loose-performance-schema-events-statements-history-long-size=1000
78loose-performance-schema-max-thread-instances=200
79loose-performance-schema-session-connect-attrs-size=2048
80
81# Enable everything, for maximun code exposure during testing
82
83loose-performance-schema-instrument='%=ON'
84
85loose-performance-schema-consumer-events-stages-current=ON
86loose-performance-schema-consumer-events-stages-history=ON
87loose-performance-schema-consumer-events-stages-history-long=ON
88loose-performance-schema-consumer-events-statements-current=ON
89loose-performance-schema-consumer-events-statements-history=ON
90loose-performance-schema-consumer-events-statements-history-long=ON
91loose-performance-schema-consumer-events-waits-current=ON
92loose-performance-schema-consumer-events-waits-history=ON
93loose-performance-schema-consumer-events-waits-history-long=ON
94loose-performance-schema-consumer-global-instrumentation=ON
95loose-performance-schema-consumer-thread-instrumentation=ON
96
97binlog-direct-non-transactional-updates
98