1# Default values that applies to all MySQL Servers 2[mysqld] 3open-files-limit= 1024 4local-infile 5character-set-server= latin1 6 7# Increase default connect_timeout to avoid intermittent 8# disconnects when test servers are put under load see BUG#28359 9connect-timeout= 60 10 11log-bin-trust-function-creators=1 12key_buffer_size= 1M 13sort_buffer_size= 256K 14max_heap_table_size= 1M 15 16loose-innodb_data_file_path= ibdata1:10M:autoextend 17loose-innodb_buffer_pool_size= 24M 18loose-innodb_lru_scan_depth= 100 19loose-innodb_write_io_threads= 2 20loose-innodb_read_io_threads= 2 21loose-innodb_log_buffer_size= 1M 22loose-innodb_log_file_size= 5M 23loose-innodb_log_files_in_group= 2 24 25slave-net-timeout=120 26 27log-bin=mysqld-bin 28 29# MAINTAINER: 30# the loose- syntax is to make sure the cnf file is also 31# valid when building without the performance schema. 32 33# Run tests with the performance schema instrumentation 34loose-enable-performance-schema 35# Run tests with a small number of instrumented objects 36# to limit memory consumption with MTR 37loose-performance-schema-accounts-size=100 38loose-performance-schema-digests-size=200 39loose-performance-schema-hosts-size=100 40loose-performance-schema-users-size=100 41loose-performance-schema-setup-actors-size=100 42loose-performance-schema-setup-objects-size=100 43 44loose-performance-schema-events-waits-history-size=10 45loose-performance-schema-events-waits-history-long-size=10000 46loose-performance-schema-events-stages-history-size=10 47loose-performance-schema-events-stages-history-long-size=1000 48loose-performance-schema-events-statements-history-size=10 49loose-performance-schema-events-statements-history-long-size=1000 50loose-performance-schema-events-transactions-history-size=10 51loose-performance-schema-events-transactions-history-long-size=1000 52loose-performance-schema-session-connect-attrs-size=2048 53 54# Enable everything, for maximun code exposure during testing 55 56loose-performance-schema-instrument='%=ON' 57 58loose-performance-schema-consumer-events-stages-current=ON 59loose-performance-schema-consumer-events-stages-history=ON 60loose-performance-schema-consumer-events-stages-history-long=ON 61loose-performance-schema-consumer-events-statements-current=ON 62loose-performance-schema-consumer-events-statements-history=ON 63loose-performance-schema-consumer-events-statements-history-long=ON 64loose-performance-schema-consumer-events-transactions-current=ON 65loose-performance-schema-consumer-events-transactions-history=ON 66loose-performance-schema-consumer-events-transactions-history-long=ON 67loose-performance-schema-consumer-events-waits-current=ON 68loose-performance-schema-consumer-events-waits-history=ON 69loose-performance-schema-consumer-events-waits-history-long=ON 70loose-performance-schema-consumer-global-instrumentation=ON 71loose-performance-schema-consumer-thread-instrumentation=ON 72 73binlog-direct-non-transactional-updates 74 75loose-show-compatibility-56=ON 76 77