]>
Commit | Line | Data |
---|---|---|
2ad2f3ce | 1 | # The MySQL server configuration file. |
2 | # One can use all long options that the mysqld supports. | |
3 | # Run mysqld with --help to get a whole list of available options | |
4 | # $Id$ | |
5 | ||
6 | # This section must be the first! | |
7 | [mysqld] | |
3127d72f PG |
8 | datadir = /var/lib/mysql/db |
9 | pid-file = /var/lib/mysql/mysql.pid | |
2ad2f3ce | 10 | port = 3306 |
3127d72f | 11 | socket = /var/lib/mysql/mysql.sock |
2ad2f3ce | 12 | user = mysql |
13 | ||
9051d690 AM |
14 | #character-set-server=latin2 |
15 | #collation-server=latin2_general_ci | |
16 | #init-connect="SET NAMES latin2" | |
17 | ||
df187c4e AM |
18 | # Use passwords compatible with old 4.0 mysqld |
19 | #old-passwords | |
20 | ||
2ad2f3ce | 21 | # Don't use system locking |
22 | #skip-locking | |
23 | ||
24 | # Don't allow connections over the network by default | |
25 | skip-networking | |
26 | ||
b7986924 PG |
27 | # Emergency option. Use only if you really need this. |
28 | #skip-grant-tables | |
29 | ||
2ad2f3ce | 30 | # Log connections and queries. It slows down MySQL so it's disabled by default |
31 | #log = /var/log/mysql/log | |
32 | ||
33 | # Log all updates. | |
34 | #log-update = /var/log/mysql/update | |
35 | # Log some extra information to update log | |
36 | #log-long-format | |
37 | ||
38 | # Log all isam changes | |
39 | #log-isam = /var/log/mysql/isamlog | |
40 | ||
41 | # Language | |
42 | #language = polish | |
43 | ||
b0f33e42 | 44 | # |
2ad2f3ce | 45 | # Internal server variables |
b0f33e42 | 46 | # |
c040b04c | 47 | |
d4ec3e38 | 48 | #set-variable = back_log=5 |
49 | #set-variable = connect_timeout=5 | |
50 | #set-variable = delayed_insert_timeout=300 | |
51 | #set-variable = delayed_insert_limit=100 | |
52 | #set-variable = flush_time=0 | |
2f36e721 ER |
53 | #set-variable = join_buffer_size=131072 |
54 | #set-variable = key_buffer_size=8M | |
d4ec3e38 | 55 | #set-variable = long_query_time=10 |
c040b04c | 56 | #set-variable = max_allowed_packet=1M |
d4ec3e38 | 57 | #set-variable = max_connections=100 |
5138ec12 | 58 | #set-variable = max_user_connections=0 |
d4ec3e38 | 59 | #set-variable = max_connect_errors=10 |
60 | #set-variable = max_delayed_insert_threads=20 | |
61 | #set-variable = delayed_queue_size=1000 | |
62 | #set-variable = max_join_size=4294967295 | |
63 | #set-variable = max_sort_length=1024 | |
64 | #set-variable = max_write_lock_count=4294967295 | |
65 | #set-variable = net_buffer_length=16384 | |
66 | #set-variable = record_buffer=131072 | |
2f36e721 | 67 | #set-variable = sort_buffer_size=2M |
d4ec3e38 | 68 | #set-variable = table_cache=64 |
c040b04c | 69 | #set-variable = tmp_table_size=1M |
d4ec3e38 | 70 | #set-variable = thread_stack=65536 |
71 | #set-variable = wait_timeout=28800 | |
2ad2f3ce | 72 | |
73 | ||
b0f33e42 | 74 | |
75 | # | |
76 | # MyISAM tables options | |
77 | # | |
78 | ||
79 | # Don't flush key buffers between writes for any MyISAM | |
80 | #delay-key-write-for-all-tables | |
81 | ||
82 | # Repair automatically on open if the table wasn't closed properly. | |
83 | myisam-recover | |
84 | # | |
85 | #set-variable = myisam_sort_buffer_size=4M | |
86 | ||
87 | ||
88 | ||
89 | # | |
90 | # InnoDB tables options (see MySQL manual) | |
91 | # | |
92 | ||
93 | #innodb_data_home_dir = /var/lib/mysql/innodb/data | |
94 | #innodb_data_file_path = 00:10M;01:20M | |
95 | #set-variable = innodb_mirrored_log_groups=1 | |
96 | #innodb_log_group_home_dir = /var/lib/mysql/innodb/log | |
97 | #set-variable = innodb_log_files_in_group=3 | |
98 | #set-variable = innodb_log_file_size=30M | |
99 | #set-variable = innodb_log_buffer_size=8M | |
100 | ||
101 | #innodb_flush_log_at_trx_commit=1 | |
102 | #innodb_log_arch_dir = /var/lib/mysql/innodb/log | |
103 | #innodb_log_archive=0 | |
104 | #set-variable = innodb_buffer_pool_size=80M | |
105 | #set-variable = innodb_additional_mem_pool_size=10M | |
106 | #set-variable = innodb_file_io_threads=4 | |
107 | #set-variable = innodb_lock_wait_timeout=50 | |
108 | ||
109 | ||
110 | # | |
111 | # Berkeley DB tables options | |
112 | # | |
113 | # Don't use berkeley db (saves a lot of memory) | |
114 | #skip-bdb | |
115 | ||
116 | #bdb-home = /var/lib/mysql/db | |
117 | #bdb-log-dir = /var/lib/mysql/bdb/log | |
118 | #bdb-tmpdir = /var/lib/mysql/bdb/tmp | |
119 | ||
120 | ||
121 | #bdb-lock-detect = DEFAULT | |
122 | ||
123 | # Don't synchronously flush logs. | |
124 | #bdb-no-sync | |
125 | ||
126 | # Don't start Berkeley DB in recover mode. | |
127 | #bdb-no-recover | |
128 | ||
129 | # Start Berkeley DB in multi-process mode (Don't use `DB_PRIVATE' | |
130 | # when initializing Berkeley DB | |
131 | #bdb-shared-data | |
132 | ||
133 | #set-variable = bdb_max_lock=1000 | |
134 | ||
135 | ||
2ad2f3ce | 136 | # used for logs rotation |
137 | [mysqladmin] | |
138 | user = mysql_logrotate | |
139 | password = |