I'd bump up these two settings. innodb_buffer_pool_size=32M innodb_additional_mem_pool_size=16M
I'm not sure what the max is on innodb_buffer_pool_size, but that is where innodb caches data. The more that is in cache means less disk reads which equals speed. walt K Old wrote: > > Hello everyone, > > I am using a product that came packaged with Mysql 4.0.8-gamma and I > believe our configuration settings in my.cnf are too low and was wanting > a second opinion, and I'm aware of the my-huge.cnf file that comes > bundled with the mysql source and our variables are set way below the > my-huge.cnf defaults. We are using InnoDB tables and our tablespace > size is currently 2.3GB. We are running a 2Ghz IBM e-server with 3.5GB > RAM. Here's what are current settings are for mysqld in my.cnf: > > [mysqld] > port = 1205 > socket = /tmp/mysql.1205.sock > datadir = /home/edi/si/mysql/data > basedir = /home/edi/si/mysql > skip-locking > set-variable = key_buffer=16M > set-variable = max_allowed_packet=100M > set-variable = table_cache=64 > set-variable = sort_buffer=512K > set-variable = net_buffer_length=8K > set-variable = myisam_sort_buffer_size=8M > log-bin > server-id = 1 > transaction-isolation=READ-COMMITTED > #SI server > innodb_data_file_path = ibdata1:2256M;ibdata2:50M:autoextend > innodb_data_home_dir = /home/edi/si/mysql/var/ > innodb_log_group_home_dir = /home/edi/si/mysql/var/ > innodb_log_arch_dir = /home/edi/si/mysql/var/ > 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=32M > set-variable = innodb_additional_mem_pool_size=16M > set-variable = innodb_file_io_threads=4 > set-variable = innodb_lock_wait_timeout=600 > set-variable = wait_timeout=114748364 > > Thanks, > Kevin > -- > K Old <[EMAIL PROTECTED]> > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
