MySQL sql-bench results

June 16th, 2009 by Boštjan Škufca

UPDATE: There was a newer test performed, with MySQL 5.6.25 on Linux 4.2.3 64bit, on almost the same hardware. designer phone case iphone 8 You can see it here. iphone 8 plus marble case with name This is a follow-up article to the MySQL Super Smack benchmark results. lumee duo case iphone 6 Results from sql-bench benchmark suite can easily pinpoint some of the potential system bottlenecks. iphone 6 purse case lighting phone case iphone 6 I find it especially useful for discovering filesystem performance or – better – slowness. iphone 7 phone case character iphone 7 plus case london iphone 7 case running mirror case for iphone 8 plus Results Total execution time is: 562 seconds

# run-all-tests alter-table: Total time: 8 wallclock secs ( 0.02 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.03 CPU) ATIS: Total time: 2 wallclock secs ( 1.20 usr 0.09 sys + 0.00 cusr 0.00 csys = 1.29 CPU) big-tables: Total time: 5 wallclock secs ( 2.45 usr 0.08 sys + 0.00 cusr 0.00 csys = 2.53 CPU) connect: Total time: 50 wallclock secs (12.74 usr 4.50 sys + 0.00 cusr 0.00 csys = 17.24 CPU) create: Total time: 31 wallclock secs ( 1.20 usr 0.44 sys + 0.00 cusr 0.00 csys = 1.64 CPU) insert: Total time: 397 wallclock secs (97.95 usr 13.61 sys + 0.00 cusr 0.00 csys = 111.56 CPU) select: Total time: 44 wallclock secs ( 8.71 usr 0.88 sys + 0.00 cusr 0.00 csys = 9.59 CPU) transactions: Test skipped because the database doesn’t support transactions wisconsin: Total time: 3 wallclock secs ( 0.91 usr 0.23 sys + 0.00 cusr 0.00 csys = 1.14 CPU) TOTALS 562.00 123.77 19.82 143.59 3425950

System specification can be found here. iphone 8 cases boys baseus iphone 7 battery case iphone 6 case pink hard ReiserFS vs others In the age of Linux kernel 2.4.x we used ReiserFS v3 as the filesystem of choice. iphone 7 plus phone bling case fruit iphone 7 case With the available options of ReiserFS (journal, performance), ext2 (stable but slow) and ext3 (probably stable, but not so speedy as ReiserFS) the choice was obvious. surf iphone 8 case iphone 7 phone case marble black I skipped few years then and this year again tried using ReiserFS with linux 2.6.29.1 but it turned out to be even slower than ext2 was in the old days. lamborghini iphone 8 case apple iphone 8 case shockproof liverpool phone case iphone 7 plus Googling around for an answer gave some hints that ReiserFS has an issue with someting called BIG_KERNEL_LOCK on 2.6 kernels. iphone 7 case carbon I didn’t really investigate further, but went down the ext3 way. 8 iphone cases leather girly phone case iphone 6 plus Comments on test-create If test-create takes much more time than, say, 30-60 seconds, then you definitely have a problem with filesystem write performance. iphone 6 case bape On HP DL360 and DL380 class of servers this correlates with the presence and activation of BBWC (Battery-Backed Write Cache enabler kit). love moschino case for iphone 6 tpu case iphone 6 charger cases iphone 6 Without BBWC and hence without write cache enabled, this test took more than 10 minutes to complete. Thus, if you are purchasing some new HP servers, be sure that you also order BBWCs. iphone 6 plus cases disney quotes lv phone case iphone x Question about test-insert Looking at the test times, this test-insert result is really standing out. Again, I do not have any other data to compare it to, but somewhere deep down in my memory I seem to remember that the total time for all the tests was around 300 seconds. iphone 7 cases bling iphone 7 case mercedes superhero phone case iphone 8 plus This obviously means that this test-insert result is the bad guy here. amazing iphone 6 case Can someone comment on this result, or paste in the comments his own? Thanks. apple red iphone 8 plus case steven brown iphone 6 case iphone 7 plus flamingo case iphone 7 disney phone cases Feedback If you have any questions, recommendations or benchmark results to compare, do not hesitate to leave a comment. iphone 6 solar case tellur case iphone 7 plus sons of anarchy iphone 7 plus case sequin phone case iphone 6 iphone 7 cases michael kors iphone 8 case disney castle UPDATE1: 2014-09-09 I forgot to mention explicitly that this system is running 32bit version of Slackware UPDATE2: 2014-09-09 Fortunately this system is still up and running. iphone charge case 7 iphone 7 plus phone cases light up During these five years only storage has been expanded with 300GB 10K SAS drives in RAID 1 configuration. ted baker cases iphone 7 plus 360 iphone 8 case silicone tendlin iphone 7 case Software was upgraded regularly and is currently on MySQL 5.5.39 and pending 5.6.20 upgrade. I retested the test-create today and the result was 85 wall-clock seconds. case motorcycle iphone 8 plus rfid iphone x case This is almost 3x worse as initially. knomo iphone 7 case The server is currently lightly loaded.


3 Responses to “MySQL sql-bench results”

  1. Peter DeGregorio says:

    I have two virutally identical comptuers and get drastically different results from sql-bench with insert taking the most time.

    Operation seconds usr sys cpu tests
    Computer 0: insert 334.00 0.44 0.25 0.69 9768
    Computer 1: insert 26.00 0.36 0.06 0.42 9768

  2. bostjan says:

    If insert times differ, I suggest testing you filesystem / storage device performance. At least 2 parameters should be considered:
    – raw sequential write speed
    – raw random read (write) IOPS
    (both on raw block device and on the filesystem).

  3. […] post provides fresh sql-bench results for the test that was performed a while back. is a follow up post with fresh […]

Leave a Reply

 

*