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
