PBXT in tpcc-mysql benchmark

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

Raw results 1 thread 16 threads

[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

[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

./tpcc_start localhost tpccpbxt root "" 100 16 10 3600