you are knowing that most buffer-sizes are per connection and so if you have 100 connections your machine will consume 3200 MB Memory for each per-connection buffer?
try the settings below and i bet your machine will be much faster your "innodb_log_buffer_size" is way too small and instead wasting memory for per-connection buffers use it for "innodb_buffer_pool_size" which should be in a perfect world as big as the whole database some of this settings made the difference creeping to flying with a 15 GB dbmail-database on a virtual machine with 10 GB RAM and in summary MySQL 5.5 with all this settings is really really fast mysql 5.5-optimizings if there is enough memory innodb_buffer_pool_size = 5120M innodb_buffer_pool_instances = 5 innodb_purge_threads = 1 innodb_max_purge_lag = 200000 innodb_thread_concurrency = 32 innodb_thread_sleep_delay = 10 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 600 transaction-isolation = READ-COMMITTED "innodb_io_capacity" with 600 asumes really fast disks! _______________ however, this are recommended changes for 5.1 i hope i have stripped all my mysql-5.5-optimizings, if not take a look in the error-log if it fails to start for unknown variables key_buffer_size = 256M sort_buffer_size = 320K read_rnd_buffer_size = 256K join_buffer_size = 320K read_buffer_size = 128K preload_buffer_size = 128K myisam_sort_buffer_size = 128M innodb_buffer_pool_size = 512M innodb_max_dirty_pages_pct = 60 innodb_additional_mem_pool_size = 64M innodb_log_file_size = 128M innodb_log_buffer_size = 256M innodb_thread_concurrency = 8 innodb_thread_sleep_delay = 10 innodb_flush_log_at_trx_commit = 2 innodb_support_xa = 1 innodb_lock_wait_timeout = 50 innodb_table_locks = 0 Am 23.08.2011 22:37, schrieb Robin Horforth: > skip-external-locking > key_buffer_size = 256M > max_allowed_packet = 16M > table_open_cache = 256 > sort_buffer_size = 32M > read_buffer_size = 32M > read_rnd_buffer_size = 4M > myisam_sort_buffer_size = 128M > thread_cache_size = 8 > query_cache_size= 128M > thread_concurrency = 4 > innodb_data_home_dir = /mail/db > innodb_data_file_path = ibdata1:500M:autoextend > innodb_log_group_home_dir = /mail/db > innodb_buffer_pool_size = 512M > innodb_additional_mem_pool_size = 40M > innodb_log_file_size = 128M > innodb_log_buffer_size = 8M > innodb_flush_log_at_trx_commit = 1 > innodb_lock_wait_timeout = 50
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
