May 20, 2013

Open Source, the MySQL market (and TokuDB in particular)

May 10, 2013 By 12 Comments

I was reviewing the Percona Live sponsors list the other day and pondering the potential success stories associated with this product or that one…. and as I was preparing to put more thought on the topic, a PlanetMySQL post caught my eye. It was penned by Mike Hogan and titled, “Thoughts on Xeround and Free!” [...]

Filed Under: MySQL Tagged With: , , , , , , ,

Percona Live MySQL Conference 2013 wrap-up

April 29, 2013 By Leave a Comment

The Percona Live MySQL Conference & Expo 2013 was April 22-25 in Santa Clara, California. This was Percona’s second year organizing the conference and we were very pleased with the event and the feedback (check the #perconalive hashtag for a sampling of the great comments such as this from Tom Krouper or this from John [...]

Filed Under: Events and Announcements, MySQL, Percona Live Tagged With: , , , , , , , , , , ,

10 years of MySQL User Conferences

April 11, 2013 By 6 Comments

In preparing for this month’s Percona Live MySQL Conference and Expo, I’ve been reminiscing about the annual MySQL User Conference’s history – the 9 times it previously took place in its various reincarnations – and there are a lot of good things, fun things to remember. 2003 was the year that marked the first MySQL user conference [...]

Filed Under: Events and Announcements, Insight for DBAs, Insight for Developers, MySQL, Percona Live Tagged With: , , ,

MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

March 14, 2013 By 2 Comments

While preparing the webinar I will deliver this Friday, I ran into a quite interesting (although not very impacting) optimizer issue: a “SELECT *” taking half the time to execute than the same “SELECT one_indexed_column” query in MySQL 5.6.10. This turned into a really nice exercise for checking the performance and inner workings of one [...]

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , ,

InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

This is part 2 in a 3 part series. In part 1, we took a quick look at some initial configuration of InnoDB full-text search and discovered a little bit of quirky behavior; here, we are going to run some queries and compare the result sets. Our hope is that the one of two things [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Analyzing Slow Query Table in MySQL 5.6

February 18, 2013 By 1 Comment

Next week I’m teaching an online Percona Training class, called Analyzing SQL Queries with Percona Toolkit.  This is a guided tour of best practices for pt-query-digest, the best tool for evaluating where your database response time is being spent. This month we saw the GA release of MySQL 5.6, and I wanted to check if any [...]

Filed Under: Events and Announcements, Insight for DBAs, Live Virtual Training, MySQL, Percona Toolkit, Training Tagged With: , , , , , , ,

Percona MySQL University: Looking for a venue in Toronto next month

January 31, 2013 By 1 Comment

Thank you to everyone who attended Percona MySQL University in Raleigh, N.C. We had a great turnout and a lot of positive feedback! What’s next for Percona MySQL University? Next week we’re going to hold events in Montevideo and Buenos Aires which are gathering significant local interest! In March we’re focusing on Toronto – We’ll [...]

Filed Under: Events and Announcements, MySQL, Percona MySQL University Tagged With: ,

Initial Keynote Speakers for the Percona Live MySQL Conference & the MySQL Community Awards

January 18, 2013 By Leave a Comment

I’m pleased to announce the initial list of keynote speakers for the Percona Live MySQL Conference & Expo, April 22-25 in Santa Clara, California. The conference promises great content with over 90 speakers in more than 110 sessions, 15 tutorials, and multiple keynotes. The MySQL Community Awards 2013 are also now accepting nominations. And do [...]

Filed Under: Events and Announcements, MySQL

The Optimization That (Often) Isn’t: Index Merge Intersection

December 14, 2012 By 6 Comments

Prior to version 5.0, MySQL could only use one index per table in a given query without any exceptions; folks that didn’t understand this limitation would often have tables with lots of single-column indexes on columns which commonly appeared in their WHERE clauses, and they’d wonder why the EXPLAIN plan for a given SELECT would [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete

December 3, 2012 By 1 Comment

As Percona Live London is raging in the UK, I thought it fitting to remind everyone about the next big Percona Live: MySQL Conference and Expo 2013 in Santa Clara, Californa on April 22-25, 2013.  You can register NOW for this conference, and the Super Saving Registration deadline ends on December 28th, so be sure to [...]

Filed Under: Events and Announcements, MySQL
« Older Posts