mysqld.conf

   1 # The MySQL server configuration file.
   2 # One can use all long options that the mysqld supports.
   3 # Run mysqld with --help to get a whole list of available options
   4 # $Id$
   5
   6 # This section must be the first!
   7 [mysqld]
   8 datadir     = /var/lib/mysql
   9 pid-file    = /var/lib/mysql/mysql.pid
  10 port        = 3306
  11 socket      = /var/lib/mysql/mysql.sock
  12 user        = mysql
  13
  14 # Don't use system locking
  15 #skip-locking
  16
  17 # Don't allow connections over the network by default
  18 skip-networking
  19
  20 # Log connections and queries. It slows down MySQL so it's disabled by default
  21 #log        = /var/log/mysql/log
  22
  23 # Log all updates.
  24 #log-update = /var/log/mysql/update
  25 # Log some extra information to update log
  26 #log-long-format
  27
  28 # Log all isam changes
  29 #log-isam    = /var/log/mysql/isamlog
  30
  31 # Language
  32 #language   = polish
  33
  34 # Internal server variables
  35 #set-variable = back_log=5
  36 #set-variable = connect_timeout=5
  37 #set-variable = delayed_insert_timeout=300
  38 #set-variable = delayed_insert_limit=100
  39 #set-variable = flush_time=0
  40 #set-variable = join_buffer=131072
  41 #set-variable = key_buffer=8388600
  42 #set-variable = long_query_time=10
  43 #set-variable = max_allowed_packet=1048576
  44 #set-variable = max_connections=100
  45 #set-variable = max_connect_errors=10
  46 #set-variable = max_delayed_insert_threads=20
  47 #set-variable = delayed_queue_size=1000
  48 #set-variable = max_join_size=4294967295
  49 #set-variable = max_sort_length=1024
  50 #set-variable = max_write_lock_count=4294967295
  51 #set-variable = net_buffer_length=16384
  52 #set-variable = record_buffer=131072
  53 #set-variable = sort_buffer=2097144
  54 #set-variable = table_cache=64
  55 #set-variable = tmp_table_size=1048576
  56 #set-variable = thread_stack=65536
  57 #set-variable = wait_timeout=28800
  58
  59
  60 # used for logs rotation
  61 [mysqladmin]
  62 user        = mysql_logrotate
  63 password    =