Announcement

Announcement Module
Collapse
No announcement yet.

XtraDB5.1.37-7 tuning suggestions?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • XtraDB5.1.37-7 tuning suggestions?

    Hi, Guys

    I compared XtraDB5.1.37-7 and MySQL5.4.1-beta performance using sysbench (simple, read, complex) and dbt2 10WH. All the data can be fully cached into innodb_buffer_pool. So no read disk io.

    However I found XtraDB5.1.37-7 was 8%~16% lower than mysql5.4.1 for sysbench and dbt2.

    Do you have any tuning suggestions?

    My hardware is 2 sockets, quad-core processors with HT. OS is RHEL5.2.

    Both mysql5.4 and xtradb are started with the below options. Others are the default value.
    --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_flush_log_at_trx_commit=2 \
    --innodb_flush_method=O_DIRECT \
    --innodb_log_files_in_group=6 \
    --innodb_support_xa=0 \
    --innodb_doublewrite=0 \
    --innodb-status-file=0 \
    --innodb_thread_concurrency=0 \

    Your suggestions/comments are appreciated.

    Thx, Xuekun

  • #2
    download newer

    Comment

    Working...
    X