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