EmergencyEMERGENCY? Get 24/7 Help Now!

Using Gearman for Nightly Build and Test

 | October 16, 2009 |  Posted In: Tokutek, TokuView

At Tokutek, Rich Prohaska used Gearman to automate our nightly build and test process for TokuDB for MySQL. Rich is busy working on TokuDB, so I’m writing up an overview of the build and test architecture on his behalf. Build and Test Process Rich created a script, nightly.bash, that gets kicked off every night as […]

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

XtraDB storage engine release 1.0.4-8

 | October 12, 2009 |  Posted In: MySQL, Percona Software

Dear Community, We are glad to present you release 8 of XtraDB. The release includes following new features: The release is base on 1.0.4 version of InnoDB plugin. We thank Schooner Information Technology for sponsoring and testing the port of XtraDB to 1.0.4 MySQL 5.1.39 as a base release Fixed bugs: Bugs#413858: Crash from failed […]

Read More