I've got a Linux server (RH 7.3, 2.4.18, 1.5GB RAM) which runs good but could always be faster. Memory is relatively cheap all things considered, so we just added 4GB to it. I can increase innodb_buffer_pool_size from the 800M I had it at previously only to about 1500M without problems. I was hoping to take more advantage of this additional RAM. I've searched the mailing lists, notes/docs on innodb.com and mysql.com, etc... Is there a good "tuning guide" on maximizing MySQL/InnoDB performance with a large amount of RAM somewhere? Here's my current config, any suggestions? Thanks in advance!
datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock default-table-type=innodb innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata 6:2000M;ibdata7:2000M innodb_data_home_dir = /var/lib/innodb/ set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /var/lib/iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=100M set-variable = innodb_log_buffer_size=32M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = /var/lib/iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=1500M set-variable = innodb_additional_mem_pool_size=100M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 tmpdir = /data/tmp basedir=/var/lib [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid PS. MySQL fails to start if I up the buffer_pool_size much more than the 1.5GB --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
