[mysqld] tmpdir=/tmp/heikki max-connections=2000 skip-networking #sync-binlog=1 #innodb_support_xa=0 #log #innodb_table_locks=0 #skip-safemalloc #bdb-no-sync #skip-innodb server-id=1 #default-character-set=utf8 #lower_case_table_names=1 language=/home/heikki/mysql-5.1/sql/share/english default-table-type=innodb log-bin=1 set-variable = max_binlog_size=10M port=3307 socket=/home/heikki/bugsocket #skip-locking basedir=/home/heikki datadir=/home/heikki/bugs/data/ #transaction-isolation = READ-UNCOMMITTED # Uncomment the following row if you move the MySQL distribution to another # location #basedir = d:/mysql/ #set-variable = table_cache=2049 #set-variable = sort_buffer_size=32M #set-variable = myisam_sort_buffer_size=384M #set-variable = read_buffer_size=32M #set-variable = read_rnd_buffer_size=32M #set-variable = tmp_table_size=384M set-variable = thread_cache=32 set-variable = thread_concurrency=8 #set-variable=key_buffer=35M #set-variable=long_query_time=5 set-variable=max_allowed_packet=8M #set-variable=low_priority_updates=1 #set-variable=query_cache_size=32M #set-variable=query_cache_limit=2M #set-variable=query_cache_type=1 # Uncomment the following if you are using InnoDB tables innodb_file_per_table=1 innodb_buffer_pool_size=100M innodb_log_file_size=20M #innodb_thread_concurrency=1