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
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
Comment