Difference between revisions of "Default mysql.cnf"

From Kolmisoft Wiki
Jump to navigationJump to search
(New page: [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user =...)
 
 
Line 1: Line 1:
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock


[client]
[mysqld_safe]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock
socket          = /var/run/mysqld/mysqld.sock
nice            = 0


[mysqld_safe]
[mysqld]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0


[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir        = /usr
datadir        = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-external-locking


user           = mysql
bind-address           = 127.0.0.1
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir        = /usr
datadir        = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-external-locking


bind-address           = 127.0.0.1
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack           = 128K
thread_cache_size      = 8
query_cache_limit      = 1M
query_cache_size        = 16M
log_bin                = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size        = 100M
skip-bdb


key_buffer              = 16M
[mysqldump]
quick
  quote-names
max_allowed_packet      = 16M
max_allowed_packet      = 16M
thread_stack            = 128K
thread_cache_size      = 8
query_cache_limit      = 1M
query_cache_size        = 16M
log_bin                = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size        = 100M
skip-bdb


[mysqldump]
[mysql]
quick
quote-names
max_allowed_packet      = 16M
 
[mysql]


[isamchk]
[isamchk]
key_buffer              = 16M
key_buffer              = 16M


!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/conf.d/

Latest revision as of 12:25, 25 February 2008

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0
[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-external-locking
bind-address            = 127.0.0.1
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 128K
thread_cache_size       = 8
query_cache_limit       = 1M
query_cache_size        = 16M
log_bin                 = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M
skip-bdb
[mysqldump]
quick
 quote-names

max_allowed_packet = 16M

[mysql]
[isamchk]
key_buffer              = 16M
!includedir /etc/mysql/conf.d/