Likes: 
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.
Code:[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
