All pastes #768926 Raw Edit

Untitled

public text v1 · immutable
·published 2007-11-10 23:47 UTC
rendered paste body
# * Fine Tuning
#
key_buffer		= 128M
max_allowed_packet	= 16M
thread_stack		= 4096K
thread_cache_size	= 512
#max_connections        = 100
table_cache		= 1024
#thread_concurrency     = 10
read_buffer_size	= 32M
read_rnd_buffer_size	= 64M
myisam_sort_buffer_size = 256M
tmp_table_size		= 256M
max_heap_table_size	= 256M
#
# * Query Cache Configuration
#
query_cache_limit       = 4M
query_cache_size        = 32M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log		= /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
#log_slow_queries	= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
#server-id		= 1
#log_bin			= /var/log/mysql/mysql-bin.log
# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
#expire_logs_days	= 10
#max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
#
[mysqldump]
quick
quote-names
max_allowed_packet	= 64M

[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition

[isamchk]
key_buffer		= 512M