EmergencyEMERGENCY? Get 24/7 Help Now!

Level 2 Flash cache is there

 | April 27, 2010 |  Posted In: Hardware and Storage, MySQL

As I mentioned in my talk An Overview of Flash Storage for Databases I see in the near and middle term future a lot of interest for using Flash storage in Level 2 caching level. The price-capacity trade-off makes Flash as the very good fit for a cache layer. Actually it is not the new […]

Read More

MySQL 5.5.4 in tpcc-like workload

 | April 21, 2010 |  Posted In: Benchmarks, MySQL

MySQL-5.5.4 ® is the great release with performance improvements, let’s see how it performs in tpcc-like workload. The full details are on Wiki page https://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start I took MySQL-5.5.4 with InnoDB-1.1, tpcc-mysql benchmark with 200W ( about 18GB worth of data), InnoDB log files are 3.8GB size, and run with different buffer pools from 20GB to […]

Read More

Is there a performance difference between JOIN and WHERE?

 | April 14, 2010 |  Posted In: MySQL

I’ve heard this question a lot, but never thought to blog about the answer. “Is there a performance difference between putting the JOIN conditions in the ON clause or the WHERE clause in MySQL?” No, there’s no difference. The following queries are algebraically equivalent inside MySQL and will have the same execution plan.

Personally, […]

Read More

xtrabackup-1.2

 | April 13, 2010 |  Posted In: MySQL, Percona Software

Dear Community, The notice is hereby given that next version 1.2 of XtraBackup software is released. The list of changes in this version includes: Changelog: XtraBackup supports now XtraDB 10 tar4ibd supports variable page size and fast_checksum of XtraDB Supported 32bit platform for Centos 5, Centos 4, Debian lenny and etch, Ubuntu Karmic, Jaunty, Intrepid, […]

Read More

Come Meet Percona In Person Next Week

 | April 8, 2010 |  Posted In: Events and Announcements, MySQL

Percona will have 14 members of our team at next week’s O’Reilly MySQL Conference in California. Drop by and meet us at booth 308 (for Percona) or 216 (for Maatkit). Bring your technical questions and problems to our experts. To make it easier for you to meet specific Perconians, check this Google calendar for when […]

Read More