From: David Schneider-Joseph (daviddavidsj.com)
Date: Tue Jan 29 2008 - 16:47:32 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Jan 29, 2008, at 6:09 PM, Jan Kirchhoff wrote:

> what hardware are you running on and you much memory do you have?
> what version of mysql?| |
> How did you set innodb_buffer_pool_size?

Hardware:
Dual AMD Opteron 246 2.0 GHz
4 GB DDR RAM (no swap being used)
Dual 146 GB SCSI drives with a RAID 1

Software:
RedHat Linux, kernel version 2.6.9-55.ELsmp
MySQL 5.0.45-community-log

InnoDB configuration:
> +---------------------------------+------------------------+
> | Variable_name | Value |
> +---------------------------------+------------------------+
> | innodb_additional_mem_pool_size | 20971520 |
> | innodb_autoextend_increment | 8 |
> | innodb_buffer_pool_awe_mem_mb | 0 |
> | innodb_buffer_pool_size | 536870912 |
> | innodb_checksums | ON |
> | innodb_commit_concurrency | 0 |
> | innodb_concurrency_tickets | 500 |
> | innodb_data_file_path | ibdata1:10M:autoextend |
> | innodb_data_home_dir | |
> | innodb_doublewrite | ON |
> | innodb_fast_shutdown | 1 |
> | innodb_file_io_threads | 4 |
> | innodb_file_per_table | ON |
> | innodb_flush_log_at_trx_commit | 1 |
> | innodb_flush_method | |
> | innodb_force_recovery | 0 |
> | innodb_lock_wait_timeout | 50 |
> | innodb_locks_unsafe_for_binlog | OFF |
> | innodb_log_arch_dir | |
> | innodb_log_archive | OFF |
> | innodb_log_buffer_size | 1048576 |
> | innodb_log_file_size | 5242880 |
> | innodb_log_files_in_group | 2 |
> | innodb_log_group_home_dir | ./ |
> | innodb_max_dirty_pages_pct | 90 |
> | innodb_max_purge_lag | 0 |
> | innodb_mirrored_log_groups | 1 |
> | innodb_open_files | 300 |
> | innodb_rollback_on_timeout | OFF |
> | innodb_support_xa | ON |
> | innodb_sync_spin_loops | 20 |
> | innodb_table_locks | ON |
> | innodb_thread_concurrency | 8 |
> | innodb_thread_sleep_delay | 10000 |
> +---------------------------------+------------------------+

> you might want to read
> http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html
> and do some tuning.

As best I can tell, our server is tuned appropriately. We've
definitely spent effort on tuning it already.

> In case that doesn't help you, you'll need to post more info on your
> config.

Done. :) Thanks for your assistance.

> Jan

David

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]