]]>
]]>

Scalability on Cisco server

Benchmark

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

Server: Percona-Server-5.1.47-11.2

Results

threadsread onlyread write
1955.16562.62
21878.911258.05
32688.011890.37
43548.682503.93
54315.543068.93
65130.433533.94
75931.374038.42
86531.084446.48
97219.84830.21
107867.615181.95
118278.715460.3
128646.75746.34
139047.845996.51
149426.556119.23
159645.376261.42
169897.246391.45
1710097.66532.84
1810240.56645.45
1910532.396795.81
2010798.527013.94
2111151.437177.58
2211518.637205.59
23118067531.35
2412089.377537.07
2512075.417494.07
2612177.297370.29
2712211.417366.76
2812158.937429.72
2912155.277421.76
3012118.047396.23
3112140.47403.5
3212074.397337.66

Scripts

sysbench

#!/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

my.cnf

[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
 
benchmark/cisco/scale/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
]]> ]]>