TPCC MySQL 5.5 VS Xtradb

Posted on

La version MySQL 5.6 arrivant pour bien en tant que Release Candidate, j’ai testé la version MySQL 5.5 contre Xtradb sur le plan des TPCC. Et Il semblerait que Mysql nous offre un produit vraiment à la hauteur des espérances en termes de performances.

Configuration de la machine:

  • CPU(s) 12 x Six-Core AMD Opteron(tm) Processor 2423 HE
  • 24 GB RAM
  • 4 x SSD INTEL-RAID 0
test : tpcc_start localhost tpcc root “” 100 16 10 3600
MySQL5.cnf :
innodb_buffer_pool_size=17G
innodb_data_file_path=ibdata1:10M:autoextend
innodb_file_per_table=ON
innodb_additional_mem_pool-size=32M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=8M
innodb_max_dirty_pages_pct=90
innodb_log_files_in_group=2
innodb_log_file_size=1024M
innodb_lock_wait_timeout=50
innodb_thread_concurrency=0
innodb_flush_method = O_DIRECT
innodb_write_io_threads=8
innodb_read_io_threads=8
innodb_io_capacity=2000
innodb_purge_thread=1
max_connections=3500
query_cache_size=0
sync_binlog=0
skip-name-resolvetable_cache=10000
XTRADB.cnf :  
transaction-isolation=REPEATABLE-READ
innodb_buffer_pool_size=15G
innodb_data_file_path=ibdata1:10M:autoextend
innodb_file_per_table=1
innodb_additional_mem_pool-size=32M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=8M
innodb_log_files_in_group=2
innodb_log_file_size=1024M
innodb_fast_checksum=1
innodb_lock_wait_timeout=50
innodb_thread_concurrency=0
innodb_flush_method             = O_DIRECT
innodb_write_io_threads=8
innodb_read_io_threads=8
innodb_io_capacity=2000
innodb_ibuf_accel_rate=20000
innodb_max_dirty_pages_pct=90
max_connections=3500
query_cache_size=0
skip-name-resolve
table_cache=10000
sync_binlog=0

Résultats assez intéressant l’INNODB de MySQL 5.5 est vraiment
plus performant et il semblerait que Percona ait du souci à ce faire sur ce point de vue.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s