EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Performance Conference 2010

 | October 23, 2009 |  Posted In: Events and Announcements, MySQL

It’s time to announce our plans for Percona Performance Conference 2010. We will hold the event on April 12th and 13th in Santa Clara, California. In the months to come we will announce the theme, the exact location (we have it reserved, but it’s subject to change), the exact dates (we may add days), and […]

Read More

Training Updates

 | October 16, 2009 |  Posted In: Events and Announcements, MySQL

I wanted to provide an update on two things: Firstly, we have opened registration for InnoDB/XtraDB training in Los Angeles (Nov 18th). The second is that while I am in New York City for training (Oct 29th), I’ll be giving a (free) talk at the MySQL Meetup group there (Oct 28th). We love to speak […]

Read More

How (not) to find unused indexes

 | October 16, 2009 |  Posted In: Insight for DBAs, MySQL

I’ve seen a few people link to an INFORMATION_SCHEMA query to be able to find any indexes that have low cardinality, in an effort to find out what indexes should be removed.  This method is flawed – here’s the first reason why:

The cardinality of status index is woeful, but provided that the application […]

Read More

MySQL-Memcached or NOSQL Tokyo Tyrant – part 2

 | October 16, 2009 |  Posted In: Benchmarks, Cloud and NoSQL, MySQL

Part 1 of our series set-up our “test”  application and looked at boosting performance of the application by buffer MySQL with memcached.  Our test application is simple and requires only 3 basic operations per transaction 2 reads and 1 write.  Using memcached combined with MySQL we ended up nearly getting a 10X performance boost from […]

Read More

Tuning for heavy writing workloads

 | October 14, 2009 |  Posted In: Benchmarks, Insight for DBAs, MySQL

For the my previous post, there was comment to suggest to test db_STRESS benchmark on XtraDB by Dimitri. And I tested and tuned for the benchmark. I will show you the tunings. It should be also tuning procedure for general heavy writing workloads. At first, <tuning peak performance>. The next, <tuning purge operation> to stabilize […]

Read More

Percona welcomes Devananda van der Veen

 | October 14, 2009 |  Posted In: Events and Announcements, MySQL

On the heels of our earlier announcement of Fernando and Yves, I’m happy to welcome Devananda van der Veen to our team. Devananda, also known as Deva, is a talented, detail-oriented MySQL expert and systems administrator. His previous job was at Hydra, an advertising network, where he was sole DBA and half of the systems […]

Read More

Watch out for your CRON jobs

 | October 14, 2009 |  Posted In: Insight for DBAs, MySQL

Resolving extreme database overload for the customer recently I have found about 80 copies of same cron job running hammering the database. This number is rather extreme typically the affect is noticed and fixed well before that but the problem with run away cron jobs is way to frequent. If slow down happens on the […]

Read More