MySQL 5.5.8 vs Percona 5.5.7

• Hardware: R900 http://www.percona.com/docs/wiki/benchmark:hardware:r900
• Storage: RAID10, 8 disks
• Benchmark: tpcc-mysql, 500W (~50GB ), buffer_pool=24GB, 16 users, 8 hours
• Date: 15-Dec, 2010

[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
core
basedir=/usr/local/mysql
user=root
socket=/var/lib/mysql/mysql.sock
skip-grant-tables
server_id=1
local_infile=1
datadir=/mnt/ocz
innodb_buffer_pool_size=24G
innodb_data_file_path=ibdata1:10M:autoextend
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=8M
innodb_log_files_in_group=2
innodb_log_file_size=2000M
innodb_thread_concurrency=0
innodb_flush_method             = O_DIRECT
innodb_write_io_threads=8
innodb_read_io_threads=8
innodb_io_capacity=500
max_connections=3000
query_cache_size=0
skip-name-resolve
table_cache=10000
[mysql]
socket=/tmp/mysql.sock

[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
core
basedir=/usr/local/mysql
user=root
socket=/var/lib/mysql/mysql.sock
skip-grant-tables
server_id=1
local_infile=1
datadir=/mnt/ocz
innodb_buffer_pool_size=24G
innodb_data_file_path=ibdata1:10M:autoextend
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=8M
innodb_log_files_in_group=2
innodb_log_file_size=2000M
innodb_thread_concurrency=0
innodb_flush_method             = O_DIRECT
innodb_write_io_threads=8
innodb_read_io_threads=8
innodb_io_capacity=500
max_connections=3000
query_cache_size=0
skip-name-resolve
table_cache=10000
[mysql]
socket=/tmp/mysql.sock

set -u
set -x
set -e
export LD_LIBRARY_PATH=/usr/local/Percona-Server/lib/mysql/
ulimit -c unlimited
BD=/mnt/x25m/back/tpc500w
DR="/mnt/pztest/tpc500w"
CONFIG="/etc/my.cnf"
WT=10
RT=10800
ROWS=80000000
log2="$DR/"
function restore {
mkdir -p $DR
rm -fr $DR/*
echo $log2
for nm in ibdata1 
do
rm -f $log2/$nm
cp $BD/$nm $log2
done
cp -r $BD/mysql $DR
cp -r $BD/tpcc* $DR
sync
echo 3 > /proc/sys/vm/drop_caches
chown mysql.mysql -R $DR
chown mysql.mysql -R $log2
}
function waitm {
while [ true ]
do
mysql -e "set global innodb_max_dirty_pages_pct=0" mysql
wt=`mysql -e "SHOW ENGINE INNODB STATUS\G" | grep "Modified db pages" | sort -u | awk '{print $4}'`
if [[ "$wt" -lt 100 ]] ;
then
mysql -e "set global innodb_max_dirty_pages_pct=90" mysql
break
fi
echo "mysql pages $wt"
sleep 10
done
}
RUN_NUMBER=-1
if [ -f ".run_number" ]; then
  read RUN_NUMBER < .run_number
fi
if [ $RUN_NUMBER -eq -1 ]; then
        RUN_NUMBER=0
fi
OUTDIR=res$RUN_NUMBER
mkdir -p $OUTDIR
RUN_NUMBER=`expr $RUN_NUMBER + 1`
echo $RUN_NUMBER > .run_number
for par in 24
do
restore
export OS_FILE_LOG_BLOCK_SIZE=4096
/usr/local/mysql/libexec/mysqld --defaults-file=$CONFIG --datadir=$DR  --innodb_log_group_home_dir=$log2 --innodb_thread_concurrency=0 --innodb-buffer-pool-size=${par}GB &
MYSQLPID=$!
set +e
while true;
do
mysql -Bse "SELECT 1" mysql
if [ "$?" -eq 0 ]
then
  break
fi
sleep 30
echo -n "."
done
set -e
iostat -dx 5 2000 >> $OUTDIR/iostat.${par}res &
PID=$!
vmstat 5 2000 >> $OUTDIR/vmstat.${par}res &
PIDV=$!
cp $CONFIG $OUTDIR
cp $0 $OUTDIR
mysqladmin variables >>  $OUTDIR/mysql_variables.res
./tpcc_start localhost tpcc500 root "" 500 16 10 28800 | tee -a $OUTDIR/tpcc.${par}.out 
kill -9 $PID
kill -9 $PIDV
kill -9 $MYSQLPID
done