My problem is the following and I thank you in advance on any help offered. Show Innodb Status shows that my DB server has no free buffers. What is the significance of this, what causes this, and how bad is it? Here is the relevant part of the output of that command: BUFFER POOL AND MEMORY ---------------------- Total memory allocated 595053970; in additional pool allocated 975744 Buffer pool size 32768 Free buffers 0 Database pages 31770 Modified db pages 11 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 44820347, created 150031, written 9138368 0.37 reads/s, 0.00 creates/s, 4.75 writes/s Buffer pool hit rate 1000 / 100 I am running mysql 4.1.4 on Linux with 1 GB Memory. The DB has a mix of MyIsam and Innodb tables. The possibly relevant parts of my.cnf looks like this: max_connections=200 key_buffer = 256M sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M innodb_data_home_dir = /var/lib/mysql/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/mysql/ innodb_buffer_pool_size = 512M innodb_additional_mem_pool_size = 20M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005
