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