]>
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] | |
8 | datadir = /var/lib/mysql | |
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 | ||
34 | # Internal server variables | |
35 | #set-variable = back_log = 5 | |
36 | #set-variable = connect_timeout = 5 | |
37 | #set-variable = delayed_insert_timeout = 300 | |
38 | #set-variable = delayed_insert_limit = 100 | |
39 | #set-variable = flush_time = 0 | |
40 | #set-variable = join_buffer = 131072 | |
41 | #set-variable = key_buffer = 8388600 | |
42 | #set-variable = long_query_time = 10 | |
43 | #set-variable = max_allowed_packet = 1048576 | |
44 | #set-variable = max_connections = 100 | |
45 | #set-variable = max_connect_errors = 10 | |
46 | #set-variable = max_delayed_insert_threads = 20 | |
47 | #set-variable = delayed_queue_size = 1000 | |
48 | #set-variable = max_join_size = 4294967295 | |
49 | #set-variable = max_sort_length = 1024 | |
50 | #set-variable = max_write_lock_count = 4294967295 | |
51 | #set-variable = net_buffer_length = 16384 | |
52 | #set-variable = record_buffer = 131072 | |
53 | #set-variable = sort_buffer = 2097144 | |
54 | #set-variable = table_cache = 64 | |
55 | #set-variable = tmp_table_size = 1048576 | |
56 | #set-variable = thread_stack = 65536 | |
57 | #set-variable = wait_timeout = 28800 | |
58 | ||
59 | ||
60 | # used for logs rotation | |
61 | [mysqladmin] | |
62 | user = mysql_logrotate | |
63 | password = |