Deimos
23/07/02, 00:01
Omdat SQL soms enorm veel CPU tijd in beslag neemt heb ik mijn my.cnf geoptimaliseerd. Hieronder staat deze, maar het kan natuurlijk zijn dat ik dingen over het hoofd zie, vandaar de vraag of dat zo is en zoja wat :).
[client]
port = 3306
socket = /tmp/mysql.sock
# The MySQL server
[mysqld]
port= 3306
socket= /tmp/mysql.sock
skip-locking
set-variable = max_connections=400
set-variable = key_buffer=36M
set-variable = join_buffer=6M
set-variable = record_buffer=6M
set-variable = sort_buffer=10M
set-variable = table_cache=1536
set-variable = myisam_sort_buffer_size=40M
set-variable = thread_cache_size=530
set-variable = connect_timeout=30
set-variable = wait_timeout=30
set-variable = interactive_timeout=28800
# Try number of CPU's*2 for thread_concurrency
set-variable= thread_concurrency=3
log-slow-queries=/var/log/slow.log
log=/var/log/mysql.log
#log-bin
#server-id= 1
# Uncomment the following if you are using Innobase tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:25M;ibdata2:37M;ibdata3:100M;ibdata4:300M
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50
# Point the following paths to different dedicated disks
#tmpdir= /tmp/
#log-update = /path-to-dedicated-directory/hostname
[mysqldump]
quick
set-variable= max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable= key_buffer=128M
set-variable= sort_buffer=128M
set-variable= read_buffer=2M
set-variable= write_buffer=2M
[myisamchk]
set-variable= key_buffer=256M
set-variable= sort_buffer=256M
set-variable= read_buffer=8M
set-variable= write_buffer=8M
[mysqlhotcopy]
interactive-timeout
[client]
port = 3306
socket = /tmp/mysql.sock
# The MySQL server
[mysqld]
port= 3306
socket= /tmp/mysql.sock
skip-locking
set-variable = max_connections=400
set-variable = key_buffer=36M
set-variable = join_buffer=6M
set-variable = record_buffer=6M
set-variable = sort_buffer=10M
set-variable = table_cache=1536
set-variable = myisam_sort_buffer_size=40M
set-variable = thread_cache_size=530
set-variable = connect_timeout=30
set-variable = wait_timeout=30
set-variable = interactive_timeout=28800
# Try number of CPU's*2 for thread_concurrency
set-variable= thread_concurrency=3
log-slow-queries=/var/log/slow.log
log=/var/log/mysql.log
#log-bin
#server-id= 1
# Uncomment the following if you are using Innobase tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:25M;ibdata2:37M;ibdata3:100M;ibdata4:300M
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50
# Point the following paths to different dedicated disks
#tmpdir= /tmp/
#log-update = /path-to-dedicated-directory/hostname
[mysqldump]
quick
set-variable= max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable= key_buffer=128M
set-variable= sort_buffer=128M
set-variable= read_buffer=2M
set-variable= write_buffer=2M
[myisamchk]
set-variable= key_buffer=256M
set-variable= sort_buffer=256M
set-variable= read_buffer=8M
set-variable= write_buffer=8M
[mysqlhotcopy]
interactive-timeout