Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 6

Displaying posts with tag: sunfire (reset)

Success with OpenSolaris + ZFS + MySQL in production!
+0 Vote Up -0Vote Down

Pimp My Drive by Richard and Barb

There’s remarkably little information online about using MySQL on ZFS, successfully or not, so I did what any enterprising geek would do: Built a box, threw some data on it, and tossed it into production to see if it would sink or swim.

I’m a Linux geek, have been since 1993 ( …

  [Read more...]
How does MySQL perform on a sunfire?
+0 Vote Up -0Vote Down

If you have been reading my previous entries the answer you will think is ‘not bloody well’.

After about 3 days of tuning we doubled the throughput, and got a much nicer picture, outperforming a x86-64 machine by 2.5 times in one case.

Thanks to Luojia Chen (Jenny) from Sun, Peter Zaitsev from Mysql, and Colm MacCárthaigh & Mads Toftum from the ASF.

oh.. the benchmark.. I nearly forgot ;-)

(Oh …

  [Read more...]
so.. why does mysql run so slowly?
+0 Vote Up -0Vote Down

this is the output of dtrace -n 'pid$target:::entry{ @[probefunc] = count() }'

when I run mysqlslap -c 20 -i 20

  pthread_getspecific                                             365
  malloc_internal                                                 377
  my_malloc                                                       377
  free                                                            378
  malloc                                                          378
  my_wc_mb_filename                                               399
  my_no_flags_free                                                420
  strmake …
  [Read more...]
sunfire gets a bit of a slap -- update
+0 Vote Up -0Vote Down

ok.. now this is getting stranger.

I have 2 windows open, in one I get

$ mysqlslap --use-threads -psunfire -c 90 -i 500
Benchmark
        Average number of seconds to run all queries: 2.180 seconds
        Minimum number of seconds to run all queries: 0.779 seconds
        Maximum number of seconds to run all queries: 4.497 seconds
        Number of clients running queries: 90
        Average number of queries per client: 0

and in the other i get

$ mysqlslap --use-threads -psunfire -c 90 -i 500
Benchmark
        Average number of seconds to run all queries: 0.012 seconds
        Minimum number of seconds to run all queries: …
  [Read more...]
sunfire gets a bit of a slap
+0 Vote Up -0Vote Down

and doesn’t seem to take it too nicely :-(

I decided to install the mysql beta on my laptop (Mac Intel @2G ram and 2GHZdual core) and my sunfire (@8G ram and 16 1GHZ Ultrasparcs).

(I have it installed on a x86-64 box as well, but that machine is busy at the moment)..

so for a quick sanity check I ran mysqlslap to see how it performs.

I chose to simulate a 20 concurrent users

sunfire$ mysqlslap -psunfire -c 20 -i 20
Benchmark
        Average number of seconds to run all queries: 1.714 seconds
        Minimum number of seconds to run all queries: 0.941 seconds
        Maximum number of seconds to run all queries: …
  [Read more...]
my first benchmark for a while
+0 Vote Up -0Vote Down

In anticipation of getting my sunfire , and doing some real benchamrks with it, I thought I’d do a quick, test to see if I can still do them..kind of like a warm up excerise before you do a 1500m swim.

So I grabbed 2 idle machines I have access too, and see how mysql 5.1 performed on both.

I took Brian’s mysqlslap tool and gave it a little whirl.

the 3 boxes I had in my aresenal are

  • dual x86-64 @2.4G with 8G of ram

a

  • 280R with 2 Ultrasparc III+ processors and 4G of ram. …
  [Read more...]
Showing entries 1 to 6

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.