Scalability on Cisco server

Hardware:

http://www.percona.com/docs/wiki/benchmark:hardware:cisco_ucs_c250

sysbench, 100mln rows ( 23GB of data), oltp, read-only and read-write

Server: Percona-Server-5.1.47-11.2

#!/bin/sh
set -u
set -x
set -e

DR="/mnt/raid10"
BD="/mnt/x25e/sysb.80m"

export LD_LIBRARY_PATH=/usr/local/mysql/lib/mysql/

WT=300
RT=180

ROWS=100000000

EXPER="L2 ro"

log2="/data/log/"
#log2="$DR/"

# restore from backup


function waitm {

while [ true ]
do

mysql -e "set global innodb_max_dirty_pages_pct=0" sbtest

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" sbtest
break
fi

echo "mysql pages $wt"
sleep 10
done

}


for thread in `seq 1 32`
do

#mysql -e "select avg(id) from sbtest;" sbtest
mysql -e "select min(c) from sbtest;" sbtest

echo "sysbench $EXPER bp ${thread} warmup" >> /tmp/bench.log

sysbench --test=oltp --oltp-table-size=$ROWS --oltp-read-only=on --init-rng=on --num-threads=$thread --max-requests=0 --oltp-dist-type=uniform --max-time=$WT  --mysql-user=root  run
echo "sysbench $EXPER bp ${thread} warmup END" >> /tmp/bench.log
sleep 30

for j in 1 2 3
do
echo "$j"
echo "sysbench $EXPER bp ${thread} run $j" >> /tmp/bench.log
iostat -dx 5 >> oltp.bp$thread.iostat.res &
vmstat  5 >> oltp.bp$thread.vmstat.res &
sysbench --test=oltp --oltp-table-size=$ROWS --oltp-read-only=on --init-rng=on --num-threads=$thread --max-requests=0 --oltp-dist-type=uniform --max-time=$RT  --mysql-user=root run | tee -a oltp.thread$thread.res
echo "sysbench $EXPER bp ${thread} run $j END" >> /tmp/bench.log
kill -9 `pidof iostat`
kill -9 `pidof vmstat`
sleep 30
done



done

[mysqld]
basedir=/usr/local/Percona-Server/
user=root
#socket=/var/lib/mysql/mysql.sock
server_id=1
local_infile=1
datadir=/mnt/fio320
skip-grant-table

innodb_buffer_pool_size=180G
innodb_data_file_path=ibdata1:10M:autoextend
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=256M
innodb_log_files_in_group=2

innodb_log_file_size=3G
innodb_thread_concurrency=24
innodb_flush_method             = O_DIRECT

innodb_max_purge_lag=100000

innodb_write_io_threads=16
innodb_read_io_threads=16
innodb_io_capacity=500


innodb_buffer_pool_shm_key=5473


innodb_max_dirty_pages_pct=90

max_connections=3000
query_cache_size=0
skip-name-resolve
table_cache=10000