hi, look at insert buffer and buffer pool. This is quite interesting : http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/InnoDB_Insert_buffering.html
mathias Selon Manoj <[EMAIL PROTECTED]>: > Dear All, > I am trying to tweak some server parameters to fine tune my MySQL > (4.0.15) server on a linux box (with 6GB of ram) > > All my tables/databases use InnoDB. My question is : What is the InnoDB > equivalent of the server parameters "Key_read_request & key_reads". I > had a look at show innodb status to get an idea of these parameters but got > lost in all the information provided by show innodb status, hence would > appreciate any pointers! > > My entire my.cnf is as below for reference/additional comments that > would be useful in fine-tuning server parameters. > > Thanks for your help in advance. > > Cheers > > Manoj > > > ------ > > [client] > port=3306 > socket=/tmp/mysql.sock > > [mysqld] > user=mysql > port=3306 > key_buffer=256M > table_cache=512 > sort_buffer=8M > join_buffer_size=8M > read_buffer_size=8M > read_rnd_buffer_size=6M > max_connection=30 > max_allowed_packet= 16M > binlog_cache_size = 4M > default-table-type=innodb > log_slow_queries=/home/mysql/log/slow.query.log > log_error=/home/mysql/log/mysqld.err.log > log_long_format > long_query_time = 10 > query_cache_size = 256M > query_cache_limit = 16M > tmp_table_size = 400M > thread_cache = 8 > thread_concurrency = 8 > > # innodb_options > innodb_data_home_dir=/usr/local/mysql/ibdata/ > innodb_data_file_path=ibdata1:5G;ibdata2:1G:autoextend > innodb_mirrored_log_groups=1 > innodb_log_group_home_dir=/usr/local/mysql/ibdata/log > innodb_log_arch_dir=ibdata/log > innodb_log_files_in_group=2 > innodb_log_file_size=1500M > innodb_log_buffer_size=16M > innodb_buffer_pool_size=1500M > innodb_additional_mem_pool_size=4M > innodb_flush_log_at_trx_commit=0 > innodb_flush_method=O_DIRECT > > -- > 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]
