EmergencyEMERGENCY? Get 24/7 Help Now!

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

5.0.86-build19 Percona binaries

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

Dear Community, As of today the 19-th build of MySQL server with Percona patches is available. Comparing to the previous release it has following new features: The build is based on MySQL-5.0.86 Fix from Neil Katin to userstatv2.patch fix InnoDB slowness with large queries Fixed bugs in the build: Bug #413858 in Percona patches: “Crash […]

Read More

Percona welcomes Yves Trudeau and Fernando Ipar

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

I’m happy to extend a warm welcome to two new members of the Percona team.

First is Yves Trudeau, about whom I can say many things:

One of the top MySQL Cluster (NDB Cluster) experts in the world.
An expert on all things High Availability, including DRBD and Heartbeat.
Many years of experience with Huge Data.
Half of the Waffle Grid team.
A really nice person!

Yves joins us after a tenure of several years as a senior consultant at Sun/MySQL. Together with Matt Yonkovit, he plans to work on WaffleGrid (…

Read More

Analyzing air traffic performance with InfoBright and MonetDB

 | October 2, 2009 |  Posted In: Benchmarks, MySQL

Accidentally me and Baron played with InfoBright (see https://www.percona.com/blog/2009/09/29/quick-comparison-of-myisam-infobright-and-monetdb/) this week. And following Baron’s example I also run the same load against MonetDB. Reading comments to Baron’s post I tied to load the same data to LucidDB, but I was not successful in this. I tried to analyze a bigger dataset and I took public […]

Read More

EdUIConf 2009 recap

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

I spoke at EdUIConf 2009, a new conference in my hometown of Charlottesville, Virginia. My presentation was on web interface performance; it’s basically a twist on front-end performance in general. I slanted the talk towards web developers, rather than assuming the audience has full control over their Apache configuration. The conference was relatively short — […]

Read More