- new from scratch

[packages/mysql.git] / mysqld.conf

# The MySQL server configuration file.
# One can use all long options that the mysqld supports.
# Run mysqld with --help to get a whole list of available options
# $Id$

# This section must be the first!
[mysqld] 
datadir     = /var/lib/mysql
pid-file    = /var/lib/mysql/mysql.pid
port        = 3306
socket      = /var/lib/mysql/mysql.sock
user        = mysql

# Don't use system locking
#skip-locking

# Don't allow connections over the network by default 
skip-networking

# Log connections and queries. It slows down MySQL so it's disabled by default
#log        = /var/log/mysql/log

# Log all updates. 
#log-update = /var/log/mysql/update
# Log some extra information to update log
#log-long-format

# Log all isam changes
#log-isam    = /var/log/mysql/isamlog

# Language
#language   = polish

# Internal server variables
#set-variable = back_log              = 5
#set-variable = connect_timeout       = 5
#set-variable = delayed_insert_timeout  = 300
#set-variable = delayed_insert_limit  = 100
#set-variable = flush_time            = 0
#set-variable = join_buffer           = 131072
#set-variable = key_buffer            = 8388600
#set-variable = long_query_time       = 10
#set-variable = max_allowed_packet    = 1048576
#set-variable = max_connections       = 100
#set-variable = max_connect_errors    = 10
#set-variable = max_delayed_insert_threads  = 20
#set-variable = delayed_queue_size    = 1000
#set-variable = max_join_size         = 4294967295
#set-variable = max_sort_length       = 1024
#set-variable = max_write_lock_count  = 4294967295
#set-variable = net_buffer_length     = 16384
#set-variable = record_buffer         = 131072
#set-variable = sort_buffer           = 2097144
#set-variable = table_cache           = 64
#set-variable = tmp_table_size        = 1048576
#set-variable = thread_stack          = 65536
#set-variable = wait_timeout          = 28800


# used for logs rotation
[mysqladmin]
user        = mysql_logrotate 
password    =