I am running MySQL 5.0.75 on Ubuntu on a dual core machine with 8 gigs of ram. I am running a Drupal 5 and Drupal 6 site of the database.
I am sure my MySQL config is not optimal but I am wondering if there is any low hanging fruit I can address. Here is the heart of the current setup.
New current setup (original one at the bottom). This is a dedicated machine, btw:
key_buffer = 2G innodb_buffer_pool_size = 6G innodb_additional_mem_pool_size = 16M max_allowed_packet = 16M sort_buffer_size = 128M myisam_sort_buffer_size = 128M read_buffer_size = 128M join_buffer_size = 128M read_rnd_buffer_size = 512M thread_stack = 192K thread_cache_size = 10 thread_concurrency = 8 innodb_thread_concurrency = 8 table_cache = 2048 query_cache_limit = 2M query_cache_size = 128M
key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 query_cache_limit = 1M query_cache_size = 16M expire_logs_days = 10 max_binlog_size = 100M skip-federated default-storage-engine = InnoDB default-character-set = utf8 default-collation = utf8_general_ci