etc/kitchen-sink/my.cnf

   1 [client]
   2 socket=/srv/mysql/mysql.sock
   3
   4 [mysql]
   5 socket=/srv/mysql/mysql.sock
   6 ssl_ca=/etc/pki/tls/certs/ca.pem
   7
   8 [mysqld]
   9 datadir=/srv/mysql
  10 log_slow_queries
  11 long_query_time=4
  12 max_connections=512
  13 max_connect_errors=0
  14 wait_timeout=60
  15 interactive_timeout=60
  16 connect_timeout=10
  17 local_infile=0
  18 ft_min_word_len=3
  19 expire_logs_days=7
  20
  21 # Bump the max open files (*grumble* esp)
  22 # 2008-09-24 -- quentin
  23 open_files_limit=8192
  24
  25 log-bin=sql-bin
  26 log-bin-index=sql-bin.index
  27 relay-log=kitchen-sink-relay-bin
  28 relay-log-index=kitchen-sink-relay-bin.index
  29
  30 query_cache_limit=1M
  31 query_cache_size=128M
  32 query_cache_type=1
  33 thread_cache_size=8
  34 table_cache=512
  35 key_buffer=384M
  36 join_buffer=1M
  37 record_buffer=1M
  38 max_allowed_packet=16M
  39 sort_buffer_size=2M
  40 read_buffer_size=2M
  41 read_rnd_buffer_size=8M
  42 tmp_table_size=32M
  43 thread_concurrency=4
  44 myisam_sort_buffer_size=64M
  45
  46 innodb_buffer_pool_size=512M
  47 innodb_additional_mem_pool_size=20M
  48 innodb_log_file_size=128M
  49 innodb_log_buffer_size=8M
  50 innodb_lock_wait_timeout=50
  51 innodb_thread_concurrency=4
  52 innodb_file_per_table
  53
  54 old_passwords=1
  55 server-id=1
  56
  57 ssl_ca=/etc/pki/tls/certs/ca.pem
  58 ssl_cert=/etc/pki/tls/certs/sql.pem
  59 ssl_key=/etc/pki/tls/private/sql.pem
  60
  61 skip-bdb
  62 skip-merge
  63 skip-name-resolve
  64
  65 # Disable the "data directory" option:
  66 # <quentin> 2008-07-14
  67 skip-symbolic-links
  68
  69 [mysqldump]
  70 quick
  71 quote-names
  72 max_allowed_packet      = 16M