summaryrefslogtreecommitdiffstats
path: root/main/mysql/mysql.mycnf
blob: 6df0334eff8f3d47726a179ae1ab31aa6980c863 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
# The following values assume you have at least 32M RAM!

[client]
#password = my_password
port			= 3306
socket			= /var/run/mysqld/mysqld.sock

[safe_mysqld]
err-log			= /var/log/mysql/mysql.err

[mysqld]
# this disabled mysqld from listing on any interface.
# Use localhost to connect to socket
# If you need networking comment out the following line
skip-networking

# If innodb is needed commend next line
# if not leave this to increase performance
skip-innodb

innodb_file_per_table
user			= mysql
pid-file		= /var/run/mysqld/mysqld.pid
socket			= /var/run/mysqld/mysqld.sock
port			= 3306

# Only enable this if you really need it
# eats resources.
#log			= /var/log/mysql/mysql.log

basedir			= /usr
datadir			= /var/lib/mysql
tmpdir			= /tmp
language		= /usr/share/mysql/english
skip-locking
set-variable		= key_buffer=16M
set-variable		= max_allowed_packet=1M
set-variable		= thread_stack=128K

[mysqldump]
quick
set-variable		= max_allowed_packet=1M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
set-variable		= key_buffer=16M