]]>
]]>

MySQL 5.5.8 vs Percona 5.5.7

Configs

MySQL

[mysqld]
gdb
innodb_file_per_table = true
innodb_data_file_path = ibdata1:10M:autoextend
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 16M
innodb_buffer_pool_size = 52G
innodb_buffer_pool_instances=16
innodb_log_file_size = 2000M
innodb_log_files_in_group = 2
innodb_read_io_threads = 8
innodb_write_io_threads = 16
innodb_io_capacity=20000
port = 3306
back_log = 50
max_connections = 400
max_connect_errors = 10
table_cache = 2048
max_allowed_packet = 16M
binlog_cache_size = 16M
max_heap_table_size = 64M
sort_buffer_size = 4M
join_buffer_size = 4M
thread_cache_size = 8
query_cache_size = 0
query_cache_limit = 2M
ft_min_word_len = 4
memlock
thread_stack = 192K
transaction_isolation = READ-COMMITTED
tmp_table_size = 64M
server-id = 1
key_buffer_size = 8M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
bulk_insert_buffer_size = 8M
myisam_sort_buffer_size = 8M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
myisam_recover
skip-grant-tables
socket=/tmp/mysql.sock
user=root
[mysql]
no-auto-rehash

Percona

[mysqld]
gdb
innodb_read_ahead = none
innodb_flush_neighbor_pages = 0
innodb_adaptive_checkpoint = keep_average
innodb_file_per_table = true
innodb_data_file_path = ibdata1:10M:autoextend
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 16M
innodb_buffer_pool_size = 52G
innodb_log_file_size = 4G
innodb_log_files_in_group = 2
innodb_read_io_threads = 8
innodb_write_io_threads = 16
innodb_io_capacity = 500
port = 3306
back_log = 50
max_connections = 400
max_connect_errors = 10
table_cache = 2048
max_allowed_packet = 16M
binlog_cache_size = 16M
max_heap_table_size = 64M
sort_buffer_size = 4M
join_buffer_size = 4M
thread_cache_size = 8
query_cache_size = 0
query_cache_limit = 2M
ft_min_word_len = 4
memlock
thread_stack = 192K
transaction_isolation = READ-COMMITTED
tmp_table_size = 64M
server-id = 1
key_buffer_size = 8M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
bulk_insert_buffer_size = 8M
myisam_sort_buffer_size = 8M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
myisam_recover
socket=/tmp/mysql.sock
user=root
skip-grant-tables
[mysql]
no-auto-rehash

Running script

set -u
set -x
set -e
export LD_LIBRARY_PATH=/usr/local/Percona-Server/lib/mysql/
MYSQLDIR=/usr/local/mysql
ulimit -c unlimited
BD=/mnt/fio160/back/tpc1000w
DR="/mnt/tachion/tpc1000w"
CONFIG="/etc/my.y.558.cnf"
WT=10
RT=10800
ROWS=80000000
log2="/data/bench/"
function restore {
mkdir -p $DR
rm -fr $DR/*
rm -f $log2/ib_log*
echo $log2
cp -r $BD/mysql $DR
pagecache-management.sh cp -r $BD/tpcc1000 $DR
pagecache-management.sh cp -r $BD/ibdata1 $log2
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 trxv in 2
do
for logsz in 2000M
do
for par in 52 144
do
runid="par$par.log$logsz.trx$trxv."
restore
export OS_FILE_LOG_BLOCK_SIZE=4096
/usr/local/mysql/bin/mysqld --defaults-file=$CONFIG --datadir=$DR --innodb_data_home_dir=$log2 --innodb_log_group_home_dir=$log2 --innodb_thread_concurrency=0 --innodb-buffer-pool-size=${par}GB --innodb-log-file-size=$logsz --innodb_flush_log_at_trx_commit=$trxv  &
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 -dmx 10 2000 >> $OUTDIR/iostat.${runid}res &
PID=$!
vmstat 10 2000 >> $OUTDIR/vmstat.${runid}res &
PIDV=$!
./virident_stat.sh >> $OUTDIR/virident.${runid}res &
PIDVS=$!
$MYSQLDIR/bin/mysqladmin ext -i10 -r >> $OUTDIR/mysqladminext.${runid}res &
PIDMYSQLSTAT=$!
cp $CONFIG $OUTDIR
cp $0 $OUTDIR
mysqladmin variables >>  $OUTDIR/mysql_variables.res
./tpcc_start localhost tpcc1000 root "" 1000 32 10 3600 | tee -a $OUTDIR/tpcc.${runid}.out
kill $PIDMYSQLSTAT
kill -9 $PID
kill -9 $PIDV
kill -9 $PIDVS
kill -9 $MYSQLPID
done
done
done

Results

secPercona Server 5.5.7MySQL 5.5.8 52GPercona Server 5.5.7MySQL 5.5.8144GPercona Server 5.5.7MySQL 5.5.8
10618252775284653164096102
20755176968965927682817856
3043253065112451128794588983
40459332341309012437104859790
50461637071405113458110359801
604155375614476134671130910785
704569389714629134631126510662
805040373814615138091103210560
905207366214557136881091510251
1005153389014647138231069010186
1105237397015067139671067810041
120516240181527014468106188084
130526340491565214709106279966
1405163408215966148521080510020
1505202416915986150141097810139
1605092409616180155881123810375
1705037401016382155061132610463
1805027405916660155371153310670
1904994410216475158061158110506
2005142417416491154161167610712
2105006421016585159391174210777
2205082412016572158011190210821
2305105422516739158091181210945
2405070417416670158621183210949
250511041291668096261184710750
260505241721677023531172310948
27051374179168175241182610906
280514642901663970751181910847
290513041071679280331188614838
3005042418916895100931181516013
3105140431715533117971178015577
3205264418913456119941580613095
330519142561325611784167814024
340520943061285012597168031982
350522242081290512647168235714
360524943341279912646169767985
370529942851273212459169059753
3805279427112844117821693911366
390526643601309188111704610706
400531344051306483901685312299
410533143861297580291697912525
420530344191312080061720112654
430517044321288679521705712617
440545043791310274991710412248
450530443161355287411723612755
460533344321370671741739512659
470537744051396474091703812421
480531944061493981181724112650
490526244121489971831718112614
500529144931397972501715912723
510533644491358183941720212737
520527044731365074531723212392
530528243961371973751735212771
540529945801387575761730412876
550524644521393784571726212926
560531544911423057011739712762
570528545061402770771752312628
580519444011431376461742812434
590521345211436081741755512763
600525844621436473371744712899
610521144641451176831754312723
620526144641441588491749512800
630530644821428484841741013276
640527746651441388851759712552
650538744931435887231764413429
6605256449914229100661752510773
67053424503143298884176274242
680533445551564210254176453759
69053354615160329834176487983
700519444431603380541781910149
710524145601603240691760111039
720519045031609057111759612230
730516544541609073491770312583
740525045801591984531779613100
750516944961589894421758112982
7605096424115965100101776613236
7705271434016291105971775813144
7805202446516229114081774512973
7905301437416418117681786412994
8005205439116712114021762212721
8105217448516569118451773412989
8205262438016445120921776813089
8305128443815193122501777912576
8405279442815137117631762913153
8505248451314912124001767113284
8605233436514907123651781513166
8705263444115124123931787213083
8805204447315238121631774912952
8905252446714815121601774312912
9005233442215086119981775312857
9105143444015499118561789413231
9205223440715455124531797312827
9305197450615263125141777013098
9405224450515630123991789113188
9505193449515461125011791013269
9605211441115221126161802913064
9705314449915308125961790712718
9805228443015111124991784113118
9905229430415034122801784710923
1000528044381496212594179284783
1010518044441485112664180268211
1020502643491482312561179299199
10305266434814933122891792510004
10405202448114994124721787210328
1050513044151513174851789312388
1060539944211505574891785312714
1070526843211503772531793513074
1080515943661519988301786013261
1090519943461520085221787312806
11005074430515102103391800913053
11105144437815144114761776513154
11205121443215284123101786013027
11305136434815215121371786313189
11405255443215055126551810512777
11505201451715163125991772512936
11605182427815346125801793313163
11705119437715340123091796013175
11805135438115267123381797313182
11905120370515298123951796713218
12005107418115219125501796813180
12105129434415207120231797313263
12205232440315182124801795313083
12305235442515051124641806112611
12404998436115000124631792613250
12505164439015169125101795813258
12605136428415046125081797413235
12705061435315053124361809413313
12804985442015322119291795213029
12904940433815289124421806313188
13005075443314966125041813913270
13105031437615297125341807112589
1320518644001514212176179837181
1330468541311494212265180655227
1340486244271503112548181139113
13504955426914832125341820910840
13605065421015211123021801410076
13705075428715075126891802710871
13805238423015023122351813911926
1390520443371515385961812313253
1400504143421527682821829412548
1410505042781508756121812413296
1420515043321519785371805613283
1430508542851519580851814813232
1440515242891511094311801513209
14504975434515130115621811113241
14605205433515149120761805013241
14705173421615187123351807213169
14805326444715023120911802613337
14905181426715011123461811113203
15005153430315065123921798112945
15105146425915038121331805112895
15205114434715054124591810413302
15305073424514988125101817013308
15405015428214964124691779613208
15505022444314979121531814713191
15605078437314885124241809412893
15705168415514857126341817213299
15805000405114798125721788713227
15905001413414833125361802613288
16004966429314763122441810513048
16105051424914800126741806913328
16204859427814915126031798113328
16305094430915001124211812713138
16405080430714990121921805010001
1650504141841502712567181269308
1660500842711502112710182237864
1670498941971502412366181008786
1680518942631511512466182269741
16905124418814939126631817611501
17005280423815045126521798111692
17105027426514956126891822012516
17205101427914890124281810713095
17305142422814889101701812413473
1740494942191512694061807013046
1750511642131502978591805513131
1760483342381497882751812413312
1770495441731485289521799913501
17804878429414963103891806013200
17905114419615093108341818412818
18005101430314991119951815113373
18105205425414930123101817113349
18205160416615083121351818013420
18305065420914982125521823113453
18405105416614840126271826013065
18505227416214930125821807913181
18605141420615022124391814713434
18705080417914864121771804213372
18805070418714875126971814113337
18905234420214799127591815313052
19005149416914876125561819013306
19105159411914718124451815913436
19205204417514793124361810713547
19304950424114804126811818113517
19405065418314854125751808813488
19504995418214958126091812113270
19605020417714967124521820011769
19705089417514970125551815010496
1980503741851493412769182318246
19905057421214993128061822010515
2000508941711490712454182119832
20104987415015031124821824211535
20205037410614958127041810212911
20305062421214857123821797612945
20405094413514801123771815213418
20505196415414890126371810213366
20605073409914917114191816313424
20705206396214831105331801112970
2080510041391489279611812013491
2090511141201495477971817013507
2100510441831476693181815113527
2110512140721472087671812413033
21205130419514742103521815013466
21305081413214839107751816913578
21405104403114899112341817513583
21505025413714922119171810513219
21605040414714726126101817813269
21704926409714882126631812313424
21805118410814771122651814513416
21905010403414878124481814513399
22004976413014820127111817113168
22105080397914994127141813113437
22205101404114880127501813813419
22305010408714888124791815513316
22405066406714828123501799513591
22505078399615000126021821413592
22605079403815045126801818313443
22705059413114946124281815612962
22804968406214799125091805611680
22904978412614822126421815611481
2300496340691481512616182829564
2310503040521484412695181678866
23204970394814745124511821911216
23305019404614795125221811911461
23405082406314685127161813111213
23504867403614796127101815312648
23604920404814878126481796913224
23704910416914990128381808113161
23804911400614976121691811713554
23904941392614977126491820513434
24004769407114765119231827513615
24104690407014840110701832913628
2420487841281492693671832613342
2430500439731484292011814613028
2440511939381472594581830513524
2450508939221477770421824113634
24605117395414774109481820413573
24705135387014758115181818313294
24805264402214877114641813413227
24905184397814854118381820213502
25005067396414764122421820713535
25105338395514893126251826413484
25205170397014619125661807013489
25305040393814932123231822612983
25405068377814716124391829513600
25505087396414679126261815613723
25605148391714679126051831213660
25705175396814780127151815313312
25805057397414900125931824213401
25905118402514908122211814413413
26005091391214620127001747210863
26105195392514672127051673012157
26205116392214652127271816311167
2630516039321473312191182148867
26405040398914761127501821111397
26505219401514723127741823612673
26605153394814729128651824311675
26705110383914727126021814012234
26805138392114808126551815613270
26905075383414679127651815813373
27004998381514885127301825613265
27105140387314740123161807813509
27204926397314620125521803513618
27305022388614813125261827213529
27405237397814785112491811613723
27505172393314751107951822513378
2760506639421481995791800813280
2770504339721480794911821813669
2780496239801480598491817113483
27905029386514631100471824313219
2800511438671475297381818213602
28105052383614772101761811813540
28205158383214795106301829513523
28305161389614712119791801813518
28405153394814637121661810113666
28505104392414912122951824313483
28605182392414742123371818613233
28705173374214851125721821513713
28805199380514685125861825213664
28905068382614711123561817613632
29005065373714890125781818213438
29105162373814634126981826612999
29205023383814816126231814412386
29305076389214724124561827112030
29405015377114914123271816610918
29505003380614714126791819411045
29605199387414703126571813510798
29705069384314690122791807912394
29805093385014900123561826110612
29905008384114782126651816212748
30005002383314620127211818812940
30105098383914660127071831513850
30204993382014687128081827813341
30305008370814642127951830013284
30405004375914800123811828013587
30505025377414770125631819113711
30604879372314536127281817913326
30704848374812177126711807113349
30805016379414750118111820513713
30905161375814668112491814913690
31005069378814581101901817713493
3110497936271471598251817913375
3120506638651453398201826713632
3130503136581474798551836813589
3140484836671463495501816313664
31504864368114438101361821913509
31605039378114747103491830113279
31704881370714274111421816213721
31804941370014586115671816113676
31904927387114096121731821713555
32004746369314489123741813713257
32104922355614570126411813813751
32205075370214621125531822013557
32305019379314491124731813613248
32405041373414554125381822612560
32505023378414641121981835512440
32605110373514638127301819711259
32705120352614596125221828611026
3280496137181449912673182569448
32904927365414513124891823211772
33004945365914647125841826212114
33105093363114537126291818811667
33204963365414506126611830013334
33304998365014367122841804513438
33404989344114464125561818313741
33504916363414547127681814313286
33605049365314473127791823313560
33704981365914403127341822613668
33804930360414453128271824513764
33904875377014324123991810913754
34005019364614504126731821813367
34105025351214460125901825813588
34205065363914428120751815113656
34304973352314497110101828713560
34405099364114626104751806813522
34505201351714510104331828713246
3460494236141466297321815313754
3470502935361455397621822213727
3480495036751459797021816513635
3490496435891461897951818213745
3500491035421464598581815313516
35104048362414474104321823813448
35205125355514280114011819313702
35305031364114469108571840213608
35404961358114462119011824513597
35505106358414517120521825013203
35604950359214342122711820813262
35704959353514649122851813812906
35805059350114527122881818010607
35905099356514405126681823911858
36005006355714551125711810811672
 
benchmark/mysql558/cisco_ucs/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
]]> ]]>