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