libs/mysql/conf/my.cnf

   1 [client]
   2 port            = 3306
   3 socket          = /var/run/mysqld.sock
   4
   5 [mysqld]
   6 user            = root
   7 socket          = /var/run/mysqld.sock
   8 port            = 3306
   9 basedir         = /usr
  10
  11 ############ Don't put this on the NAND #############
  12 # Figure out where you are going to put the databases
  13 # And run mysql_install_db --force
  14 datadir         = /mnt/data/mysql/
  15
  16 ######### This should also not go on the NAND #######
  17 tmpdir          = /mnt/data/tmp/
  18
  19 skip-external-locking
  20
  21 bind-address            = 127.0.0.1
  22
  23 # Fine Tuning
  24 key_buffer              = 16M
  25 max_allowed_packet      = 16M
  26 thread_stack            = 192K
  27 thread_cache_size       = 8
  28
  29 # Here you can see queries with especially long duration
  30 #log_slow_queries       = /var/log/mysql/mysql-slow.log
  31 #long_query_time = 2
  32 #log-queries-not-using-indexes
  33
  34 # The following can be used as easy to replay backup logs or for replication.
  35 #server-id              = 1
  36 #log_bin                        = /var/log/mysql/mysql-bin.log
  37 #expire_logs_days       = 10
  38 #max_binlog_size         = 100M
  39 #binlog_do_db           = include_database_name
  40 #binlog_ignore_db       = include_database_name
  41
  42
  43 [mysqldump]
  44 quick
  45 quote-names
  46 max_allowed_packet      = 16M
  47
  48 [mysql]
  49 #no-auto-rehash # faster start of mysql but no tab completition
  50
  51 [isamchk]
  52 key_buffer              = 16M
  53
  54