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]
