List:Falcon Storage Engine« Previous MessageNext Message »
From:Hakan Kuecuekyilmaz Date:April 15 2009 4:26pm
Subject:Weekly Falcon/InnoDB DBT2 Overview 2009-04-10
View as plain text  
Hello benchmark fans,

sad news, but I want to keep you up to date.

* caneland is still out of order and needs a hardware replacement.
* All other machines crashed during the 100 warehouses run. Were
machine crash means that the machines did not repsond to ssh for
three days and had to be rebooted.

News for this week:
- The crashes were due to a severe memory leak, which was fixed
yesterday. We hope to get new numbers for DBT2 by next Monday.

Change set used:
revno: 3107
revision-id: vvaintroub@stripped
parent: vvaintroub@stripped
committer: Vladislav Vaintroub <vvaintroub@stripped>
branch nick: mysql-6.0-falcon-team
timestamp: Tue 2009-04-07 22:16:05 +0200

caneland.mysql.com[1] numbers can be found here:
https://intranet.mysql.com/~hakank/caneland/weekly_dbt2_overview/weekly_dbt2_overview.php

lu0009.mysql.com[2] numbers can be found here:
https://intranet.mysql.com/~hakank/lu0009/weekly_dbt2_overview/weekly_dbt2_overview.php

nehalem-1.mysql.com[3] numbers can be found here:
https://intranet.mysql.com/~hakank/nehalem-1/weekly_dbt2_overview/weekly_dbt2_overview.php

walldorf@home[4] numbers can be found here:
https://intranet.mysql.com/~hakank/walldorf/weekly_dbt2_overview/weekly_dbt2_overview.php

Brief overview
****************
*** caneland ***
****************
- Out of order!

**************
*** lu0009 ***
**************
- Machine crashed!

*****************
*** nehalem-1 ***
*****************
- Machine crashed!

****************
*** walldorf ***
****************
- Machine crashed!

Todo:
  - Remove results from crashed runs in mean value calculation.
  - Add more information from INFORMATION_SCHEMA tables like Falcon's
  system memory usage or summary of active/pending_commit/pending_completion.
  Also talk to Ann to get more insight to Falcon metrics.
  - On walldorf put falcon_serial_log_dir to SATA disk to see
  whether the battery backed up RAID controller is the source of
  huge performance gain we saw lately.
  - Get a Solaris SPARC and Intel/AMD machine for DBT2.

Setup: datadir is on RAID10 and logdir is on separate disk (for InnoDB).

Configuration is:
MYSQLD_CONFIG_BASE="--no-defaults \
  --socket=/tmp/mysql.sock"
MYSQLD_CONFIG_GENERAL="$MYSQLD_CONFIG_BASE \
  --basedir=$FALCON \
  --datadir=$DATA_DIR \
  --tmpdir=/tmp \
  --language=${FALCON}/sql/share/english \
  --key_buffer_size=8M \
  --table_cache=4096 \
  --skip-grant-tables \
  --sort_buffer_size=2M \
  --read_buffer_size=1M \
  --tmp_table_size=67108864 \
  --thread_cache=1024 \
  --query_cache_size=0 \
  --query_cache_type=0 \
  --max_allowed_packet=512M \
  --max_connections=1601 \
  --log-error"
MYSQLD_CONFIG_FALCON="$MYSQLD_CONFIG_GENERAL \
  --skip_innodb \
  --default_storage_engine=Falcon \
  --falcon_io_threads=10 \
  --falcon_record_memory_max=650M \
  --falcon_page_cache_size=1650M \
  --falcon_page_size=8k \
  --falcon_serial_log_dir=$DATA_DIR \
  --falcon_serial_log_buffers=100 \
  --falcon_record_scavenge_threshold=70 \
  --falcon_consistent_read=off"
MYSQLD_CONFIG_INNODB="$MYSQLD_CONFIG_GENERAL \
  --skip_falcon \
  --default_storage_engine=InnoDB \
  --innodb_data_home_dir=$DATA_DIR \
  --innodb_data_file_path=ibdata1:10M:autoextend \
  --innodb_log_group_home_dir=$LOG_DIR \
  --innodb_buffer_pool_size=2300M \
  --innodb_additional_mem_pool_size=20M \
  --innodb_log_file_size=650M \
  --innodb_log_buffer_size=16M \
  --innodb_lock_wait_timeout=50 \
  --innodb_file_io_threads=10 \
  --innodb_flush_log_at_trx_commit=1 \
  --innodb_flush_method=O_DIRECT \
  --innodb_log_files_in_group=6 \
  --innodb_support_xa=0 \
  --innodb_doublewrite=0 \
  --innodb-status-file=0 \
  --skip-innodb-adaptive-hash-index \
  --innodb_max_dirty_pages_pct=70 \
  --innodb_thread_concurrency=0"


[1] caneland.mysql.com Ubuntu 8.10
Quad HexaCore @ 2.6GHz. Intel Xeon with 16MB L2 cache, 32GB RAM, hardware
RAID 10 on 4 x 15k RPM SAS disks.

[2] lu0009.mysql.com Ubuntu 8.10
Quad DualCore @ 3.4Ghz. Intel Xeon (with hyperthreading) with 16MB L2 cache, 8GB RAM,
hardware RAID 10 on 4 x 15k RPM SAS disks. This machine has unofficial Intel CPUs.

[3] nehalem-1.mysql.com Ubuntu 8.10
Dual DualCore @ 2.4Ghz. Intel Xeon (with SMT) with 16MB L2 cache, 16GB RAM,
RAID10 on 4 x SATA disk.

[4] walldorf@home RHEL5
Dual DualCore @ 2Ghz. Intel Xeon with 4MB L2 cache, 8GB RAM, hardware
RAID 10 on 4 x 15k RPM SAS disks.


Best regards,

Hakan

-- 
Hakan Küçükyılmaz, Senior Software Engineer DBTG/MySQL +49 160
98953296
Sun Microsystems GmbH     Sonnenallee 1, DE-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer:  Thomas Schroeder, Wolfang Engels, Dr. Roland Boemer
Vorsitz d. Aufs.rat.: Martin Haering   HRB MUC 161028     49.011, 8.376

Thread
Weekly Falcon/InnoDB DBT2 Overview 2009-04-10Hakan Kuecuekyilmaz15 Apr