[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user = mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords = 1
back_log = 75
skip-locking
skip-bdb
skip-innodb
low_priority_updates = 1
concurrent_insert = 2
max_connections = 100
interactive_timeout = 240
wait_timeout = 240
connect_timeout = 10
tmp_table_size = 4M
max_heap_table_size = 4M
max_allowed_packet = 4M
max_connect_errors = 1000
thread_concurrency = 8
#log-bin = mysql-bin
query_cache_type = 1
query_cache_size = 16M
query_cache_limit = 32M
query_cache_min_res_unit = 8M
query_prealloc_size = 1024K #65536
query_alloc_block_size = 2048K #131072
thread_cache_size = 4
#start at 4
table_cache = 2000483
open_files_limit = 400098
read_rnd_buffer_size = 4M
bulk_insert_buffer_size = 4M
key_buffer = 256M
log_slow_queries = /var/log/mysql-slow.log
log-queries-not-using-indexes = 1
long_query_time = 10
join_buffer_size = 8M
read_buffer_size = 8M
sort_buffer_size = 8M
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 64M
sort_buffer_size = 64M
[myisamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_safe]
nice = -5
open_files_limit = 400098
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here. Note: ndbd init
# script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"
[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"