May 21, 2013

Quickly finding unused indexes (and estimating their size)

I had a customer recently who needed to reduce their database size on disk quickly without a lot of messy schema redesign and application recoding.  They didn’t want to drop any actual data, and their index usage was fairly high, so we decided to look for unused indexes that could be removed. Collecting data It’s [...]

Percona Live MySQL Conference and Expo 2013 – News from the Committee – Part 1

I was honored to be asked to be a member of the committee for the “big” MySQL conference: Percona Live MySQL Conference and Expo 2013 in Santa Clara, CA.  Personally, I’ve been attending this conference for 6 or 7 years and missing it only when my wife was pregnant with a due date in April [...]

Percona Live NY 2012 Super Saver discounts end tomorrow. Book Now!

If you’re looking for best prices for Percona Live NY 2012, taking place Oct 1,2 in New York do not delay and book now. Super Saver discounts ends tomorrow, which can save you hundreds of dollars off conference prices list prices. These are the best prices you can get by booking early – There will [...]

Introducing Zend DBi as a MySQL Replacement on IBM i

You might have heard that Oracle made the decision not to support MySQL for IBM i any longer. This is certainly understandable. However, there are still users who want to continue running IBM i and MySQL. That’s why we’re happy to announce that we have assisted Zend to introduce Zend DBi as a drop-in replacement [...]

Percona is Speaking At Open Source Data Center Conference in Nuremberg, Germany

Percona has 2 talks lined up at OSDC in Nuremberg, Germany: – Taking hot backups with XtraBackup by Alexey Kopytov – Expert Troubleshooting: Resolving MySQL Problems Quickly  by Kenny Gryp Feel free to come and say Hi! On April 25 & 26, 2012 the Open Source Data Center Conference will invite experienced administrators and architects [...]

How We Got Here

We have spent months planning and preparing for the MySQL conference that begins tomorrow. It seems appropriate to reflect on this process, where the open source and business communities are now, and what we have planned for the future. The annual April MySQL conference was a strong and growing event for years, drawing hundreds of [...]

Optimize Your SQL With Percona’s Online Query Advisor!

Wouldn’t it be nice if you could get expert advice on your SQL queries to find problems in them, the same way that programmers can use lint-check tools to warn about bugs in their C?

Such a simple mistake, but it’s the kind of thing that James Bond movies are made of, isn’t it? [...]

Why not make a tool to improve existing configurations?

A couple of users of our very popular MySQL Configuration Wizard have submitted feedback such as “I’d love to input my existing server settings and get suggestions on how to improve it.” This sounds like it would be great, doesn’t it? We’ve considered doing this, and even partially implemented it. But during our pre-release testing, [...]

Online MySQL Configuration Wizard from Percona

Merry Christmas! Just in time for the holidays, we have released a new tool to help you configure and manage your MySQL servers. Our online MySQL Configuration Wizard can help you generate a good basic configuration file for a server. This MySQL tuning wizard is our answer to the commonly asked question, “what is a [...]

Announcing Percona Live Washington DC MySQL Conference

If you are close to Washington DC, you should plan to attend our Percona Live event on January 11th at the DC Convention Center. We have three tracks of expert speakers on core MySQL-related topics. This event will not be as large as some of the other events we’ve run, with a capacity of about [...]