EmergencyEMERGENCY? Get 24/7 Help Now!

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

Tokutek MySQL UC Talks

 | April 14, 2010 |  Posted In: Tokutek, TokuView

I (Bradley C. Kuszmaul) am presenting two talks at the MySQL User Conference. The first talk is a 5-minute talk at tonight’s Ignite MySQL session organized by Brian Aker. I’ll present some performance measurements on the Intel X25E SSD. The bottom line is that although I can get the 3,300 random 4KB writes per second, […]

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

Customer Success Story: KAYAK uses ad hoc indexing

 | April 8, 2010 |  Posted In: Tokutek, TokuView

Fast insertion – what Tokutek excels at – isn’t only important for handling high data rates. It also enables a new way to extract value from an existing database called ad hoc indexing. KAYAK has a billion rows stored in TokuDB and adding an index for a traditional MySQL storage engine would take too long […]

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

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.