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