Buy Percona ServicesBuy Now!

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

Rebuilding MySQL with same options

 | April 8, 2010 |  Posted In: Insight for DBAs, MySQL

Every so often I am working on the system with custom compiled MySQL. How to upgrade to the new MySQL Options while preserving as much of original compilation options as possible if original build scripts are not available ? MySQL distribution has a great script called mysqlbug which was supposed to be used for bug […]

Read More

Announcing New Training Venues for May-August

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

We’ve just launched training for London, Seattle, San Francisco, Atlanta, Orlando, Columbus, Dallas, San Diego, Denver, Minneapolis, New York City, Chicago & Washington DC.  This is in addition to Los Angeles, Raleigh & Toronto – which had previously been scheduled. If you organize a meetup group in one of these cities, get in touch.  In […]

Read More

Should I buy a Fast SSD or more memory?

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

While a scale-out solution has traditionally been popular for MySQL, it’s interesting to see what room we now have to scale up – cheap memory, fast storage, better power efficiency.  There certainly are a lot of options now – I’ve been meeting about a customer/week using Fusion-IO cards.  One interesting choice I’ve seen people make […]

Read More