Ticket #16484: my.cnf

File my.cnf, 4.3 KB (added by anonymous, 4 years ago)
Line 
1# /etc/mysql/my.cnf: The global mysql configuration file.
2# $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1,v 1.4 2008/11/14 02:16:25 robbat2 Exp $
3
4# The following options will be passed to all MySQL clients
5[client]
6#password                                       = your_password
7port                                            = 3306
8socket                                          = /var/run/mysqld/mysqld.sock
9
10[mysql]
11character-sets-dir=/usr/share/mysql/charsets
12default-character-set=utf8
13
14[mysqladmin]
15character-sets-dir=/usr/share/mysql/charsets
16default-character-set=utf8
17
18[mysqlcheck]
19character-sets-dir=/usr/share/mysql/charsets
20default-character-set=utf8
21
22[mysqldump]
23character-sets-dir=/usr/share/mysql/charsets
24default-character-set=utf8
25
26[mysqlimport]
27character-sets-dir=/usr/share/mysql/charsets
28default-character-set=utf8
29
30[mysqlshow]
31character-sets-dir=/usr/share/mysql/charsets
32default-character-set=utf8
33
34[myisamchk]
35character-sets-dir=/usr/share/mysql/charsets
36
37[myisampack]
38character-sets-dir=/usr/share/mysql/charsets
39
40# use [safe_mysqld] with mysql-3
41[mysqld_safe]
42err-log                                         = /var/log/mysql/mysql.err
43
44# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations
45[mysqld]
46log-slow-queries=/var/log/mysql/log-slow-queries.log
47
48character-set-server            = utf8
49default-character-set           = utf8
50user                                            = mysql
51port                                            = 3306
52socket                                          = /var/run/mysqld/mysqld.sock
53pid-file                                        = /var/run/mysqld/mysqld.pid
54log-error                                       = /var/log/mysql/mysqld.err
55basedir                                         = /usr
56datadir                                         = /var/lib/mysql
57max_connections                                 = 250
58skip-locking
59key_buffer                                      = 16M
60max_allowed_packet                      = 1M
61table_cache                             = 64
62sort_buffer_size                        = 512K
63net_buffer_length                       = 8K
64read_buffer_size                        = 256K
65read_rnd_buffer_size            = 512K
66myisam_sort_buffer_size         = 8M
67language                                        = /usr/share/mysql/english
68
69group_concat_max_len            = 64K
70
71# security:
72# using "localhost" in connects uses sockets by default
73# skip-networking
74# bind-address                          = 127.0.0.1
75
76# log-bin
77# server-id                                     = 1
78
79# point the following paths to different dedicated disks
80tmpdir                                          = /tmp/
81#log-update                             = /path-to-dedicated-directory/hostname
82
83# you need the debug USE flag enabled to use the following directives,
84# if needed, uncomment them, start the server and issue
85# #tail -f /tmp/mysqld.sql /tmp/mysqld.trace
86# this will show you *exactly* what's happening in your server ;)
87
88#log                                            = /tmp/mysqld.sql
89#gdb
90#debug                                          = d:t:i:o,/tmp/mysqld.trace
91#one-thread
92
93# uncomment the following directives if you are using BDB tables
94#bdb_cache_size                         = 4M
95#bdb_max_lock                           = 10000
96
97# the following is the InnoDB configuration
98# if you wish to disable innodb instead
99# uncomment just the next line
100# skip-innodb
101#
102# the rest of the innodb config follows:
103# don't eat too much memory, we're trying to be safe on 64Mb boxes
104# you might want to bump this up a bit on boxes with more RAM
105innodb_buffer_pool_size = 16M
106# this is the default, increase it if you have lots of tables
107innodb_additional_mem_pool_size = 2M
108#
109# i'd like to use /var/lib/mysql/innodb, but that is seen as a database :-(
110# and upstream wants things to be under /var/lib/mysql/, so that's the route
111# we have to take for the moment
112#innodb_data_home_dir           = /var/lib/mysql/
113#innodb_log_arch_dir            = /var/lib/mysql/
114#innodb_log_group_home_dir      = /var/lib/mysql/
115# you may wish to change this size to be more suitable for your system
116# the max is there to avoid run-away growth on your machine
117innodb_data_file_path = ibdata1:10M:autoextend:max:2G
118# we keep this at around 25% of of innodb_buffer_pool_size
119# sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size)
120innodb_log_file_size = 5M
121# this is the default, increase it if you have very large transactions going on
122innodb_log_buffer_size = 8M
123# this is the default and won't hurt you
124# you shouldn't need to tweak it
125set-variable = innodb_log_files_in_group=2
126# see the innodb config docs, the other options are not always safe
127innodb_flush_log_at_trx_commit = 1
128innodb_lock_wait_timeout = 50
129innodb_file_per_table
130
131[mysqldump]
132quick
133max_allowed_packet                      = 16M
134
135[mysql]
136# uncomment the next directive if you are not familiar with SQL
137#safe-updates
138
139[isamchk]
140key_buffer                                      = 20M
141sort_buffer_size                        = 20M
142read_buffer                             = 2M
143write_buffer                            = 2M
144
145[myisamchk]
146key_buffer                                      = 20M
147sort_buffer_size                        = 20M
148read_buffer                             = 2M
149write_buffer                            = 2M
150
151[mysqlhotcopy]
152interactive-timeout
153
154[mysqld_safe]
155err-log=/var/log/mysqld.log
Back to Top