1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
!include include/default_mysqld_autosize.cnf
[mysqld.1]
# WARNING about open_files_limit and ulimit -n
#
# mysqld checks how many files can be opened on the machine,
# and this is by definition very:
# - os dependent, see OS_FILE_LIMIT, HAVE_GETRLIMIT
# - configuration dependent, for each machine (ulimit -n), see
# my_set_max_open_files() in mysys/my_file.c,
# see getrlimit(RLIMIT_NOFILE)
#
# Based on the this, the server tunes _down_ max_connections and
# table_cache_size to match the open_files_limit found,
# which significantly interfere with this test.
#
# Solution: use a big table definition cache,
# but small values for max_connection and table_open_cache,
# to stay within open_files_limit of 1024.
#
# This is the best test we can do that has a chance to pass on all
# platforms, while still providing code coverage.
table_definition_cache=5000
table_open_cache=400
max_connections=200
open_files_limit=1024
# 10+max_connections+table_cache_size*2 = 10 + 200 + 400*2 = 1010
# max_connections*5 = 200*5 = 1000
# Automated sizing for everything
loose-performance-schema-accounts-size=-1
loose-performance-schema-digests-size=-1
loose-performance-schema-hosts-size=-1
loose-performance-schema-users-size=-1
loose-performance-schema-events-waits-history-size=-1
loose-performance-schema-events-waits-history-long-size=-1
loose-performance-schema-events-stages-history-size=-1
loose-performance-schema-events-stages-history-long-size=-1
loose-performance-schema-events-statements-history-size=-1
loose-performance-schema-events-statements-history-long-size=-1
loose-performance-schema-max-mutex-instances=-1
loose-performance-schema-max-rwlock-instances=-1
loose-performance-schema-max-cond-instances=-1
loose-performance-schema-max-file-instances=-1
loose-performance-schema-max-socket-instances=-1
loose-performance-schema-max-thread-instances=-1
loose-performance-schema-max-table-instances=-1
loose-performance-schema-max-table-handles=-1
|
