]]>
]]>

MySQL 5.5.8 vs Percona 5.5.7

Configs

MySQL

[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

Percona

[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

Running script

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

Results

minMySQL 5.5.8Percona 5.5.7
1246101759
2238072589
3227373499
4226685103
5223297296
62213110436
72197314396
82159719334
92189325443
102188628786
112068022013
121987023024
131967024041
141928424594
151889725982
161889018857
171892816272
181893514919
191870514206
201884013688
211896013282
221922413144
231878713698
24706314136
25665715608
261584916527
271850218492
281906119764
291929719926
301969914517
31197796964
321971528675
331969926840
342009124672
352438724459
362666325401
372623125950
382595826400
392580926883
402514927425
412512127766
422494626293
432467924497
442507924549
452478124408
462059624437
471045024111
481833823383
492517622522
502599817335
512557017240
522591124603
532573324176
542569623653
552536523691
562575223604
572608923817
582590324110
592529324453
602503823942
612516323376
622501222861
632497022699
642458123061
652470723638
662055123535
671180923633
681931623349
692459023672
702521221093
712623818692
722633724930
732605724739
742575223662
752548823843
762525523391
772526423191
782572923568
792535923371
802483723823
812506623830
822499623718
832483123895
842501724309
852501524269
862034823737
871280623739
881869523276
892447623085
902529323307
912602618872
922606021877
932593224059
942572723928
952576724302
962569524372
972570224135
982542323467
992500923061
1002501823291
1012463123171
1022467223219
1032457823517
1042486523461
1052485623595
1062097324252
1071360023719
1081803524076
1092379024279
1102504023659
1112522421351
1122556219627
1132561923432
1142570323087
1152577323484
1162618423277
1172563823004
1182562723540
1192515723543
1202475924105
1212401224014
1222460423567
1232447623455
1242461923400
1252457623549
1262243523474
1271404923584
1281630623596
1292238623515
1302494823579
1312530123596
1322548421151
1332559222216
1342562323387
1352515923585
1362534823604
1372565922817
1382587523166
1392564123051
1402502922769
1412513723249
1422437723027
1432465223325
1442448423787
1452445024434
1462369424134
1471568423773
1481536023172
1492066923112
1502461323298
1512493822991
1522567423082
1532567620055
1542555521911
1552536523364
1562524623605
1572537823631
1582545823975
1592535823377
1602498223087
1612445222504
1622445321958
1632508722866
1642427222566
1652435923143
1662422123311
1671828423710
1681484923905
1691816924520
1702300124074
1712451623456
1722538223286
1732544822730
1742563419525
1752572922061
1762516622476
1772520622692
1782538622829
1792509722955
1802497723362
1812477623388
1822462823276
1832441323220
1842458423361
1852483222916
1862451322848
1872185423564
1881568023288
1891600623528
1902105623345
1912404823490
1922492923559
1932510323474
1942556822723
1952581320883
1962564122405
1972518723153
1982521422319
1992538722005
2002499622535
2012462722434
2022424722525
2032463622806
2042416123166
2052420323275
2062447923874
2072454423497
2081859023360
2091572123380
2101726923431
2112224523017
2122455622973
2132449822136
2142505922892
2152526722498
2162526021083
2172550122729
2182592023182
2192534423268
2202490222863
2212485822253
2222457922190
2232440322027
2242405022186
2252411922355
2262425822817
2272436422985
2282267623007
2291713423599
2301621123561
2311893223725
2322354623355
2332408022771
2342481522367
2352499522051
2362504922331
2372507521545
2382514321737
2392523022448
2402509122708
2412515423236
2422459023275
2432470123011
2442419422906
2452392422935
2462408322652
2472406322702
2482402222771
2492132022657
2501690022642
2511639423042
2521977622889
2532351723206
2542418323148
2552516823089
2562510922726
2572501322495
2582522921785
2592495321566
2602532321520
2612551322007
2622509022009
2632422321754
2642448721968
2652439622816
2662391322665
2672409823129
2682379723190
2692401623242
2701970123003
2711661422681
2721692622599
2732052922650
2742409922921
2752478422382
2762505422907
2772476322884
2782524623186
2792493423138
2802496223048
2812466822152
2822516021876
2832486721964
2842431022022
2852420322133
2862448022155
2872378022225
2882391622294
2892395823049
2902335423154
2911879123618
2921627923159
2931731523146
2942091422889
2952366222874
2962501322528
2972487922433
2982498122306
2992483722579
3002501722630
3012516422242
3022506622127
3032478622237
3042458022723
3052427322756
3062449322288
3072402921902
3082398121917
3092392422092
3102397422479
3112351022548
3121866922269
3131673423104
3141735422673
3152049122619
3162364823490
3172487523101
3182524222750
3192540222346
3202511022421
3212474921681
3222492721947
3232497121543
3242463721581
3252445921911
3262432422138
3272443022746
3282402622463
3292406122380
3302405422576
3312378322734
3322317322101
3331859221736
3341679822172
3351781722302
3362053222682
3372362023354
3382487424034
3392506824542
3402530024309
3412527924229
3422473923752
3432495623911
3442487423783
3452449823677
3462428724279
3472483424066
3482407523967
3492402224081
3502388024210
3512408024660
3522412324900
3532278923784
3541878724603
3551708124342
3561770324394
3572092624002
3582346424046
3592482424252
3602484124118
3612524223966
3622484624188
3632450223932
3642454024476
3652517823668
3662499723911
3672407524278
3682396824001
3692373323992
3702427624348
3712398223752
3722391424530
3732405524568
3742330524361
3751896423995
3761747424088
3771756124060
3782035124249
3792326123780
3802469823552
3812482523739
3822461024088
3832499123983
3842505524108
3852502723917
3862511324291
3872479524308
3882451524254
3892422823788
3902407324191
3912391424112
3922395023806
3932343123855
3942401824123
3952363524272
3961947824451
3971774324255
3981740623966
3991977823462
4002286223523
4012477623786
4022476223659
4032465723567
4042488623948
4052499823783
4062518224096
4072479524191
4082422923784
4092406323819
4102403924170
4112385624043
4122394323865
4132386324082
4142383723642
4152413024025
4162399624146
4171976324163
4181807424378
4191720323384
4201892023854
4212216623639
4222428023585
4232452123205
4242495023889
4252492623624
4262479124429
4272490124182
4282489123691
4292482624047
4302433724334
4312393223953
4322377623731
4332355523559
4342358124305
4352369424138
4362380624153
4372399824097
4382098724233
4391821824219
4401767824087
4411825424134
4422098323718
4432396923446
4442473423388
4452446923833
4462493623764
4472492424189
4482500924160
4492483523933
4502460024022
4512441124174
4522410824226
4532383524166
4542396423534
4552348723807
4562357423861
4572380023926
4582372623803
4592223424054
4601900023896
4611783824012
4621790923730
4631999723934
4642314323650
4652471223582
4662463523623
4672473023531
4682464823690
4692492923966
4702500623578
4712474823504
4722436223830
4732385023884
4742438323788
4752389323754
4762383923870
4772375223600
4782349423801
4792353323922
4802271523791
 
benchmark/mysql558/r900/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
]]> ]]>