]]>
]]>

PBXT in tpcc-mysql benchmark

  • Storage: Intel SSD X25-M 160GB INTEL SSDSA2M160G2GC
  • Benchmark: tpcc-mysql, 100W ( 10GB of data), 1 and 16 concurrent users

Results

Raw results 1 thread 16 threads

Configs

PBXT

[mysqld]
basedir=/usr/local/mysql-5.1.46-pbxt
user=root
socket=/var/lib/mysql/mysql.sock


#datadir=/bench
skip-grant-table

pbxt_index_cache_size=10GB
pbxt_record_cache_size=10GB
pbxt_checkpoint_frequency=4GB
pbxt_log_file_threshold=256MB
pbxt_data_file_grow_size=16MB
pbxt_row_file_grow_size=2MB
pbxt_log_buffer_size=256K
pbxt_log_cache_size=128MB
pbxt_transaction_buffer_size=1MB


max_connections=3000
query_cache_size=0
skip-name-resolve

table_cache=10000

[mysql]

socket=/var/lib/mysql/mysql.sock

[client]
socket=/var/lib/mysql/mysql.sock

XtraDB:

[mysqld]
basedir=/usr/local/mysql
user=root
socket=/var/lib/mysql/mysql.sock
server_id=1
local_infile=1
tmpdir=/mnt/fio
datadir=/bench/db_xtradb
skip-grant-table
log_slow_queries=ON
slow_query_log_file=slow.log
innodb_buffer_pool_size=20G
innodb_data_file_path=ibdata1:10M:autoextend
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=1
innodb_fast_checksum=1
innodb_log_buffer_size=8M
innodb_log_files_in_group=2
innodb_log_file_size=1900M
innodb_thread_concurrency=0
innodb_flush_method             = O_DIRECT
innodb_write_io_threads=8
innodb_read_io_threads=8
innodb_io_capacity=2000
innodb_max_dirty_pages_pct=90
max_connections=3000
query_cache_size=0
skip-name-resolve
table_cache=10000
[mysql]
socket=/var/lib/mysql/mysql.sock
[client]
socket=/var/lib/mysql/mysql.sock

script:

./tpcc_start localhost tpccpbxt root "" 100 16 10 3600
 
benchmark/pbxt/tpcc/start.txt · Last modified: 2011/07/17 21:05 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
Contact Us 24 Hours A Day
SupportContact us 24×7
Emergency? Contact us for help now!
Sales North America(888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training(855) 55TRAIN or
(925) 271-5054

 

Share This
]]> ]]>