Greetings,
I am running MySQL (version 4.0.15 max) database on Linux (RH9) box. This
linux box is a dedicated database server with following h/w configuration:
CPU: 2 * 2.4 Ghz Xeon Processor, 512 K 533 FSB
Ram : 6GB
Hdd: 36GB * 5 raid config
Typically, this database has less number of client connections but those
who connect generally run highly analytical stuff off the database. Also the
database size is pretty huge (around 40 gb). After reading though the manuals,
specifically some of the performance enhancement tips, I build the my.cnf as
show below.
Now on to the real question, Do you MySQL gurus think that given all the
details, Is there anyway to enhance the my.cnf file for better
performance/speed ?
Your kind help would be greatly appreciated.
Best Regards
Manoj
----------------------- my.cnf file -------------------------------------
[client]
port=3306
socket=/tmp/mysql.sock
[mysqld]
user=mysql
port=3306
key_buffer=512M
table_cache=512
sort_buffer=2M
read_buffer_size=4M
read_rnd_buffer_size=4M
max_connection=100
max_allowed_packet= 1M
default-table-type=innodb
log_slow_queries=/home/mysql/log/slow.query.log
log_error=/home/mysql/log/mysqld.err.log
log_long_format
# innodb_options
innodb_data_home_dir=/usr/local/mysql
innodb_data_file_path=ibdata/ibdata1:3G;ibdata/ibdata2:3G: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=512M
innodb_log_buffer_size=8M
innodb_buffer_pool_size=1G
innodb_additional_mem_pool_size=4M
innodb_flush_log_at_trx_commit=0
innodb_flush_method=O_DIRECT
----------------------- End of my.cnf file -------------------------
