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