The Micron P320h SSD is an SLC-based PCIe solid-state storage device which claims to provide the highest read throughput of any server-grade SSD, and at Micron’s request, I recently took some time to put the card through its paces, and the numbers are indeed quite impressive. For reference, the benchmarks for this device were performed [...]
L2 cache for MySQL
October 25, 2012 By 13 Comments
The idea to use SSD/Flash as a cache is not new, and there are different solutions for this, both OpenSource like L2ARC for ZFS and Flashcache from Facebook, and proprietary, like directCache from Fusion-io. They all however have some limitations, that’s why I am considering to have L2 cache on a database level, as an [...]
Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
Over 200 attendees attended last week’s Percona Live NY event. This year we structured event different than in 2011 with Tutorial Day allowing for in-depth 3 hour presentations for those looking to dive deep into specific topics. We also added an Expo Hall which allowed a lot of MySQL Ecosystem participant to meet their prospective [...]
Multiple MySQL instances on Fusion-io ioDrive
October 7, 2011 By 6 Comments
It is known that MySQL due internal limitations is not able to utilize all CPU and IO resources available on modern hardware. Idea is to run multiple instances of MySQL to gain better performance on Fusion-io ioDrive card. Full report is available in PDF
InnoDB compression woes
May 20, 2011 By 14 Comments
InnoDB compression is getting some traction, and I see quite contradictory opinions. Someone has successful deployments in productions, and someone says that compression in current implementation is useless. To get some initial impression about performance I decided to run some sysbench with multi-tables benchmarks. I actually was preparing to do complex research, but even first [...]
Want a discount to Percona Live?
May 6, 2011 By Leave a Comment
We’ve given discount coupon codes to all of our Percona Live sponsors, so watch the Twitter tag #perconalive to find discount announcements. Here’s the list of sponsoring organizations: Clustrix Vork Continuent Fusion-io Infobright Pentaho Schooner Information Technology SkySQL Virident Webyog Akiban Couchbase EffectiveMySQL Facebook New Relic OmniTI Sphinx Tokutek We Build Pages Zmanda DaniWeb New [...]
How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
Many of the prominent companies in the MySQL ecosystem are Percona customers, including hardware manufacturers, software developers, hosted service providers, and appliance developers. We perform paid and unpaid research on their products, and we publish blog posts related to their products or services. Independence and objectivity are core Percona values. How do we balance the [...]
Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
It’s finally here! Percona Server Percona Server 5.5.8-20.0 is now available for download. This is a beta release of Percona’s enhancements to the MySQL 5.5.8 server. Here are some highlights: Performance and scalability improvements throughout the server and storage engine Optimizations for flash storage such as SSD, Virident, and FusionIO Optimizations for cloud computing The [...]
Percona Live is on Wednesday – thank you to all our sponsors
February 14, 2011 By Leave a Comment
Percona Live is in only two days away – and we’ve managed to completely sell out (something I predicted earlier). Before I go into details, I want to thank three sponsors who have been absolutely awesome: Clustrix is providing an open bar all evening, New Relic is providing all attendees with lunch and Fusion-io is [...]
Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
In my post MySQL 5.5.8 and Percona Server: being adaptive I mentioned that I used innodb-log-block-size=4096 in Percona Server to get better throughput, but later Dimitri in his article MySQL Performance: Analyzing Percona’s TPCC-like Workload on MySQL 5.5 sounded doubt that it really makes sense. Here us quote from his article: “Question: what is a [...]
