Thursday, June 4th, MySQL and Kickfire will be holding a webinar to show how end users can achieve faster and more scalable MySQL reporting and analytics with Kickfire.  The webinar will cover:

• Survey data from MySQL users on what they view as their top analytics requirements
• An overview of the different options available to MySQL users looking to do reporting and analytics
• An in-depth review of the Kickfire technology
• Industry and customer performance benchmark results of the Kickfire solution

Register for this web presentation �  

Recently, one of the engineers in ISV Engineering worked with Zmanda to create an article on how to use ZFS snapshots with Zmanda Recovery Manager for MySQL on OpenSolaris.  The article details how to deploy ZRM for MySQL on OpenSolaris and details the performance of ZRM on a Sun Fire x4500 using ZFS.  Check out the article here.

 

If you are using MySQL with Innodb and you also use ZFS, then you should check out Neel's latest blog entry.  He gives some best practice advice. 

http://blogs.sun.com/realneel/entry/mysql_innodb_zfs_best_practices

Recently, there was a great scalability milestone for the memcached community.  A single-socket T2 server (released over 1.5 years ago) shows World Record numbers with memcached that is traditionally deployed on dual-socket AMD/Intel servers.  Full details can be found at:  

 http://blogs.sun.com/zoran/entry/scaling_memcached_500_000_ops

Additionally, memcached results on Nehalem systems can be found here:

http://blogs.sun.com/shanti/entry/memcached_on_nehalem1

http://blogs.sun.com/shanti/entry/multi_instance_memcached_performance 

MySQL 5.4 Benchmarks In-Depth

Thursday, May 21, 2009

Join us for this informative technical webinar presented by performance expert, Allan Packer, Principal Engineer at Sun Microsystems. In this webinar Allan will give an overview of the scalability and performance improvements of MySQL 5.4. This version can yield up to 90% faster response times, and scalability up to 16-way x86 servers and 64-way CMT servers. Allan will also explore in depth, several benchmarks concerning MySQL 5.4, including Sysbench results on CMT and Nehalem systems plus an OLTP workload derived from an industry-standard benchmark. If you are interested learning about the performance improvements in MySQL 5.4 and related benchmarks, this webinar is for you!

http://www.mysql.com/news-and-events/web-seminars/display-343.html

Hopefully, at this point, you have heard about the new MySQL release, MySQL 5.4, which focuses on performance improvements (mainly for Innodb).  Details on benchmarks that were run for this release can be found at Allan Packer's blog here.  He talks about Sysbench performance on Nehalem with 5.4 (Linux and Solaris) as well as scalability of sysbench on 64-way CMT systems.  

There is a new blueprint solution available that shows Web 2.0 application deployment on Sun servers and the OpenSolaris operating system using MySQL. It shows how to scale a medium sized Web 2.0 site with a million registered users with open source technologies, and includes detailed configuration and tuning information for the deployment, along with tips for obtaining the best performance from such a configuration. The solution uses Olio—a Web 2.0 toolkit that Sun has invested in—to help customers analyze and scale deployments. Olio allows users to performance test new technologies in a stable environment without having to devise expensive, cumbersome tests on production applications.  You can get the blueprint by going to:

 http://www.sun.com/offers/details/820-7729.html