# 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 =