]>
Commit | Line | Data |
---|---|---|
a2b3ed98 ER |
1 | # The MySQL server configuration file. |
2 | # vim:ft=mycnf | |
3 | # | |
4 | # One can use all long options that the mysqld supports. | |
5 | # Run mysqld with --help to get a whole list of available options | |
a2b3ed98 ER |
6 | |
7 | # This section must be the first! | |
13ce82d8 | 8 | [mysqld] |
9 | datadir = @clusterdir@/mysqldb/db | |
10 | pid-file = @clusterdir@/mysqldb/mysql.pid | |
11 | socket = @clusterdir@/mysqldb/mysql.sock | |
12 | port = 3306 | |
13 | user = mysql | |
14 | ||
a2b3ed98 | 15 | # ssl options |
1037ce3a ER |
16 | #ssl-ca = /etc/certs/mysql/ca-cert.pem |
17 | #ssl-cert = /etc/certs/mysql/server-cert.pem | |
18 | #ssl-key = /etc/certs/mysql/server-key.pem | |
a2b3ed98 | 19 | #ssl-cipher = DHE-RSA-AES256-SHA |
3b5ec266 | 20 | |
a2b3ed98 ER |
21 | #character-set-server=latin2 |
22 | #collation-server=latin2_general_ci | |
23 | #skip-character-set-client-handshake | |
13ce82d8 | 24 | |
a2b3ed98 ER |
25 | # set default charset |
26 | #default-character-set = latin1 | |
13ce82d8 | 27 | |
a2b3ed98 ER |
28 | # Use passwords compatible with old 4.0 mysqld |
29 | #old-passwords | |
13ce82d8 | 30 | |
a2b3ed98 | 31 | # Don't use system locking |
13ce82d8 | 32 | skip-locking |
33 | ||
a2b3ed98 ER |
34 | # Don't listen on a TCP/IP port at all. This is a security enhancement, |
35 | # if all processes that need to connect to mysqld run on the same host. | |
36 | # All interaction with mysqld must be made via Unix sockets. | |
13ce82d8 | 37 | skip-networking |
38 | ||
a2b3ed98 ER |
39 | # IP address to bind to |
40 | #bind-address=127.0.0.1 | |
41 | ||
42 | # no dns | |
43 | #skip-name-resolve | |
44 | ||
45 | # Emergency option. Use only if you really need this. | |
46 | #skip-grant-tables | |
47 | ||
930fc2e7 ER |
48 | # http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_default-storage-engine |
49 | #default-storage-engine=MyISAM | |
50 | ||
a2b3ed98 ER |
51 | # skip startup of slave |
52 | #skip-slave-start | |
53 | ||
54 | # slave setup | |
55 | #relay-log=slave-relay-bin | |
56 | #master-host=master | |
57 | #master-user=replica | |
58 | #master-port=3306 | |
59 | #master-password=replica | |
60 | #report-host=db-slave.example.org | |
61 | ||
62 | # master does not ignore them, but we do | |
63 | #replicate-ignore-db=mysql | |
64 | #replicate-ignore-db=test | |
65 | ||
66 | #replicate-rewrite-db=delfi->delfi_ro | |
67 | ||
68 | # Replication Master Server (default) | |
69 | # binary logging is required for replication | |
70 | #log-bin=mysql-bin | |
71 | ||
72 | # If non-zero, binary logs will be purged after expire_logs_days days; possible | |
73 | # purges happen at startup and at binary log rotation. | |
74 | #expire-logs-days=30 | |
75 | ||
76 | # Normally, a slave does not log to its own binary log any updates that are | |
77 | # received from a master server. This option tells the slave to log the updates | |
78 | # performed by its SQL thread to its own binary log. For this option to have | |
79 | # any effect, the slave must also be started with the --log-bin option to | |
80 | # enable binary logging. --log-slave-updates is used when you want to chain | |
81 | # replication servers. | |
82 | #log-slave-updates | |
83 | ||
84 | # required unique id between 1 and 2^32 - 1 | |
85 | # defaults to 1 if master-host is not set but will not function as a master if omitted | |
86 | #server-id=2 | |
87 | ||
88 | # To set up N master servers, set the variables like this: | |
89 | # Set auto_increment_increment to N on each master. | |
90 | # Set each of the N masters to have a different auto_increment_offset, using the values 1, 2, ..., N | |
91 | #auto-increment-offset=1 | |
92 | #auto-increment-increment=2 | |
93 | ||
94 | # databases to be included in binlog | |
95 | #binlog-do-db=db1 | |
96 | # or excluded | |
97 | #binlog-ignore-db=mysql | |
98 | #binlog-ignore-db=test | |
99 | ||
100 | # mysqld error log (stderr) | |
10ec775d ER |
101 | log-error = /var/log/mysql/mysqld.log |
102 | log-warnings = 2 | |
103 | ||
a2b3ed98 | 104 | # Log slow queries |
94917303 | 105 | log-slow-queries = /var/log/mysql/slow.log |
13ce82d8 | 106 | |
a2b3ed98 ER |
107 | # Log connections and queries. It slows down MySQL so it's disabled by default |
108 | #log = /var/log/mysql/query.log | |
109 | ||
110 | # Log all updates. | |
111 | #log-update = /var/log/mysql/update | |
112 | # Log some extra information to update log | |
113 | #log-long-format | |
114 | ||
115 | # Language | |
116 | #language = polish | |
117 | ||
118 | # Path for temporary files. Several paths may be specified, separated by a | |
119 | # colon (:), in this case they are used in a round-robin fashion. | |
120 | #tmpdir = /var/tmp | |
121 | ||
122 | # | |
123 | # Internal server variables | |
124 | # | |
125 | ||
c37d8180 ER |
126 | #back_log=5 |
127 | #connect_timeout=5 | |
128 | #delayed_insert_timeout=300 | |
129 | #delayed_insert_limit=100 | |
130 | #flush_time=0 | |
131 | #join_buffer_size=131072 | |
132 | #key_buffer_size=8M | |
133 | #read_rnd_buffer_size=256K | |
134 | #read_buffer_size=132K | |
135 | #long_query_time=10 | |
136 | #max_allowed_packet=1M | |
137 | #max_connections=100 | |
138 | #max_user_connections=0 | |
139 | #max_connect_errors=10 | |
140 | #max_delayed_insert_threads=20 | |
141 | #delayed_queue_size=1000 | |
142 | #max_join_size=4294967295 | |
143 | #max_sort_length=1024 | |
144 | #max_write_lock_count=4294967295 | |
145 | #net_buffer_length=16384 | |
146 | #record_buffer=131072 | |
147 | #sort_buffer_size=2M | |
148 | #table_cache=64 | |
149 | #tmp_table_size=1M | |
150 | #max_heap_table_size=32M | |
151 | #thread_cache_size=16 | |
152 | #thread_stack=65536 | |
a2b3ed98 | 153 | # Try number of CPU's*2 |
c37d8180 ER |
154 | #thread_concurrency=8 |
155 | #wait_timeout=28800 | |
156 | #query_cache_size=8M | |
157 | #query_cache_limit=1M | |
a2b3ed98 ER |
158 | |
159 | # replication local log | |
c37d8180 | 160 | #max_relay_log_size=256M |
a2b3ed98 | 161 | # max size of master binlog files |
c37d8180 | 162 | #max_binlog_size=256M |
a2b3ed98 ER |
163 | |
164 | # Fulltext search options | |
165 | #ft_min_word_len=2 | |
166 | ||
167 | # | |
168 | # MyISAM tables options | |
169 | # | |
170 | ||
171 | # Don't flush key buffers between writes for any MyISAM | |
172 | # set this if you have dedicated slave server where writes aren't important | |
173 | #delay-key-write-for-all-tables | |
174 | ||
175 | # Repair automatically on open if the table wasn't closed properly. | |
13ce82d8 | 176 | myisam-recover |
a2b3ed98 | 177 | # |
c37d8180 | 178 | #myisam_sort_buffer_size=4M |
13ce82d8 | 179 | |
180 | ||
181 | ||
a2b3ed98 ER |
182 | # |
183 | # InnoDB tables options (see MySQL manual) | |
184 | # | |
185 | #skip-innodb | |
13ce82d8 | 186 | |
f019fdf5 ER |
187 | # http://stackoverflow.com/questions/2646373/mysql-data-file-wont-shrink |
188 | # http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablespaces.html | |
189 | #innodb_file_per_table | |
190 | ||
a2b3ed98 | 191 | # these are actual defaults (as of 5.0.26) |
13ce82d8 | 192 | innodb_data_home_dir = @clusterdir@/mysqldb/db |
193 | innodb_data_file_path = ibdata1:10M:autoextend | |
c37d8180 | 194 | innodb_mirrored_log_groups=1 |
13ce82d8 | 195 | innodb_log_group_home_dir = @clusterdir@/mysqldb/db |
c37d8180 ER |
196 | innodb_log_files_in_group=2 |
197 | innodb_log_file_size=5M | |
198 | innodb_log_buffer_size=1M | |
13ce82d8 | 199 | |
a2b3ed98 ER |
200 | #innodb_flush_log_at_trx_commit=1 |
201 | #innodb_log_arch_dir = @clusterdir@/innodb/log | |
202 | #innodb_log_archive=0 | |
c37d8180 ER |
203 | #innodb_buffer_pool_size=80M |
204 | #innodb_additional_mem_pool_size=10M | |
205 | #innodb_file_io_threads=4 | |
206 | #innodb_lock_wait_timeout=50 | |
13ce82d8 | 207 | |
208 | ||
a2b3ed98 ER |
209 | # |
210 | # Berkeley DB tables options | |
211 | # | |
212 | # Don't use berkeley db (saves a lot of memory) | |
213 | #skip-bdb | |
13ce82d8 | 214 | |
a2b3ed98 ER |
215 | #bdb-home = @clusterdir@/db |
216 | #bdb-log-dir = @clusterdir@/bdb/log | |
217 | #bdb-tmpdir = @clusterdir@/bdb/tmp | |
13ce82d8 | 218 | |
219 | ||
a2b3ed98 | 220 | #bdb-lock-detect = DEFAULT |
13ce82d8 | 221 | |
a2b3ed98 ER |
222 | # Don't synchronously flush logs. |
223 | #bdb-no-sync | |
13ce82d8 | 224 | |
a2b3ed98 ER |
225 | # Don't start Berkeley DB in recover mode. |
226 | #bdb-no-recover | |
13ce82d8 | 227 | |
a2b3ed98 ER |
228 | # Start Berkeley DB in multi-process mode (Don't use `DB_PRIVATE' |
229 | # when initializing Berkeley DB | |
230 | #bdb-shared-data | |
13ce82d8 | 231 | |
a2b3ed98 | 232 | #set-variable = bdb_max_lock=1000 |
13ce82d8 | 233 | |
938607e2 ER |
234 | # used for logs rotation or status check for replications |
235 | [client] | |
070de8be | 236 | user = mysql_sysadmin |
13ce82d8 | 237 | password = |