etc/my.cnf

   1 [client]
   2 socket=/srv/mysql/mysql.sock
   3
   4 [mysql]
   5 socket=/srv/mysql/mysql.sock
   6
   7 [mysqld]
   8 datadir=/srv/mysql
   9 log_slow_queries
  10 long_query_time=2
  11 max_connections=5000
  12 #max_connect_errors=10
  13 wait_timeout=600
  14 interactive_timeout=600
  15 connect_timeout=10
  16
  17 log-bin=sql-bin
  18 log-bin-index=sql-bin.index
  19 relay-log=kitchen-sink-relay-bin
  20 relay-log-index=kitchen-sink-relay-bin.index
  21
  22 skip-locking
  23 #skip-external-locking
  24
  25 query_cache_limit=1M
  26 query_cache_size=128M
  27 query_cache_type=1
  28 thread_cache_size=8
  29 table_cache=1024
  30 key_buffer=400M
  31 join_buffer=1M
  32 record_buffer=1M
  33 max_allowed_packet=16M
  34 sort_buffer_size=2M
  35 read_buffer_size=2M
  36 read_rnd_buffer_size=8M
  37 tmp_table_size=35M
  38 thread_concurrency=4
  39 myisam_sort_buffer_size=8M
  40
  41 innodb_buffer_pool_size=512M
  42 innodb_additional_mem_pool_size=20M
  43 innodb_log_file_size=200M
  44 innodb_log_buffer_size=2M
  45 #innodb_lock_wait_timeout=50
  46
  47 innodb_file_per_table
  48
  49 old_passwords=1
  50 server-id=1
  51
  52 skip-bdb
  53 #skip-networking
  54
  55 [mysqldump]
  56 quick
  57 quote-names
  58 max_allowed_packet      = 16M