Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 7

Displaying posts with tag: t2000 (reset)

MySQL Benchmark UltraSPARC T2 beats Xeon on Consolidation of OLTP & Web
Employee +0 Vote Up -0Vote Down
Recently we put together a consolidation benchmark to see how an open-source stack performs against the proprietary stack from Microsoft. Solaris, MySQL, and Sun Web Server running on the open-source UltraSPARC T2 processor were pitted against a Microsoft SW stack running on a 4-socket QC Xeon server. This benchmark highlights the continued trend to incorporate MySQL open-source databases and how it works under virtualization (Solaris Zones).

The Sun SPARC Enterprise T5220 (1.4 Ghz UltraSPARC T2 processor) and Solaris Containers managing a consolidation of Open-Source Software components (MySQL Database and Sun Java System Web Server) provided 2.4 times better performance than the HP DL580 system (four Xeon quad-core processors) and a major virtualization software, Microsoft Windows 2003 Server EE, Microsoft SQLserver database and Microsoft IIS webserver.

The Sun SPARC Enterprise

  [Read more...]
MySQL Benchmark UltraSPARC T2 beats Xeon on Consolidation of OLTP & Web
Employee +0 Vote Up -0Vote Down
Recently we put together a consolidation benchmark to see how an open-source stack performs against the proprietary stack from Microsoft. Solaris, MySQL, and Sun Web Server running on the open-source UltraSPARC T2 processor were pitted against a Microsoft SW stack running on a 4-socket QC Xeon server. This benchmark highlights the continued trend to incorporate MySQL open-source databases and how it works under virtualization (Solaris Zones).

The Sun SPARC Enterprise T5220 (1.4 Ghz UltraSPARC T2 processor) and Solaris Containers managing a consolidation of Open-Source Software components (MySQL Database and Sun Java System Web Server) provided 2.4 times better performance than the HP DL580 system (four Xeon quad-core processors) and a major virtualization software, Microsoft Windows 2003 Server EE, Microsoft SQLserver database and Microsoft IIS webserver.

The Sun SPARC Enterprise

  [Read more...]
MySQL Benchmark UltraSPARC T2 beats Xeon on Consolidation of OLTP & Web
Employee +0 Vote Up -0Vote Down
Recently we put together a consolidation benchmark to see how an open-source stack performs against the proprietary stack from Microsoft. Solaris, MySQL, and Sun Web Server running on the open-source UltraSPARC T2 processor were pitted against a Microsoft SW stack running on a 4-socket QC Xeon server. This benchmark highlights the continued trend to incorporate MySQL open-source databases and how it works under virtualization (Solaris Zones).

The Sun SPARC Enterprise T5220 (1.4 Ghz UltraSPARC T2 processor) and Solaris Containers managing a consolidation of Open-Source Software components (MySQL Database and Sun Java System Web Server) provided 2.4 times better performance than the HP DL580 system (four Xeon quad-core processors) and a major virtualization software, Microsoft Windows 2003 Server EE, Microsoft SQLserver database and Microsoft IIS webserver.

The Sun SPARC Enterprise

  [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 people..please link to the blog entry, and not the paper itself.. Thanks)

update: people were having issues downloading the PDF. so I placed a mirror of it here

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                                                         444
  pthread_self                                                    468
  memset                                                          582
  alloc_root
  [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: 0.002 seconds
        Maximum number of seconds to run all queries: 0.015 seconds
        Number of clients running queries: 90
        Average number of queries per client: 0

same machine, same user-id, same binary. the only difference is that mysql started in the ‘fast’ window.

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: 2.539 seconds
        Number of clients running queries: 20
        Average number of queries per client: 0

vs

laptop$ mysqlslap -i 20 -c 20
Benchmark
        Average number of seconds to
  [Read more...]
Showing entries 1 to 7

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.