MYSQL 5.1.50 and MYSQL5.5.8 Performance Test Report



   




picture(1)





picture(2)



MYSQL5.5 announce the innodb performance improve high, we can get the oracle test report as picture(1). with the excited mood,I test the Mysql5.1.50 buid in/plugin and mysql5.5.8,but the result is discouraging, my test report as picture(2).

my server and configure info as following:

Cpu/mem:

Intel(R) Xeon(R)  E5620 X86-64 2.40GHz
2 CPU x 8 Cores/CPU
Linux 2.6.9
32 GB RAM
CentOS release 5.3
Disk:hdparm -t /dev/sdc2=212.19 MB/sec
Mysql5.1.50 and Mysql5.5.8 are installed on the same machine

mysql5.1.50 plugin:

 default-storage-engine = INNODB
ignore-builtin-innodb
plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 15
innodb_additional_mem_pool_size = 20M
innodb_buffer_pool_size = 1024M
innodb_log_buffer_size= 10M
innodb_log_file_size = 256M
innodb_log_files_in_group = 2
innodb_thread_concurrency = 16
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_max_dirty_pages_pct = 70
transaction-isolation = READ-COMMITTED
innodb_file_format=Barracuda

mysql5.1.50 built-in:

default-storage-engine = INNODB
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 15
innodb_additional_mem_pool_size = 20M
innodb_buffer_pool_size = 1024M
innodb_log_buffer_size= 10M
innodb_log_file_size = 256M
innodb_log_files_in_group = 2
innodb_thread_concurrency = 16
innodb_max_dirty_pages_pct = 70
transaction-isolation = READ-COMMITTED

MYSQL5.5.8:

default-storage-engine = INNODB
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 15
innodb_additional_mem_pool_size = 20M
innodb_buffer_pool_size = 1024M
innodb_log_buffer_size= 10M
innodb_log_file_size = 256M
innodb_log_files_in_group = 2
innodb_thread_concurrency = 16
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_max_dirty_pages_pct =70
transaction-isolation = READ-COMMITTED
innodb_file_format=Barracuda

sysbench test script:

 ./sysbench --oltp-test-mode=complex  --oltp-reconnect-mode=session \
         --oltp-range-size=500 --oltp-point-selects=10 --oltp-simple-ranges=1 \
         --oltp-sum-ranges=1 --oltp-order-ranges=1 --oltp-distinct-ranges=1 \
         --oltp-index-updates=1 --oltp-non-index-updates=1 --oltp-nontrx-mode=select \
         --oltp-connect-delay=1000 --oltp-user-delay-min=0  --oltp-user-delay-max=0 \
         --db-ps-mode=auto --debug=off --test=oltp  \
         --mysql-host=10.224.56.188 --mysql-user=test --mysql-password=pass  --mysql-port=3307\
         --oltp-table-size=1000000 --mysql-db=meetingdb --mysql-table-engine=innodb \
         --oltp-table-name=test_with_concurrency  --num-threads=8 --max-requests=10000 --oltp-auto-inc=off \
         --mysql-engine-trx=yes  run