Emergency

Monthly Archives: January 2009

Profiling MySQL stored routines

These days I’m working with a customer who has an application based entirely on stored routines on MySQL side. Even though I haven’t worked much with stored procedures, I though it’s going to be a …

Read More
 

Fix of InnoDB/XtraDB scalability of rollback segment

Recently I wrote about InnoDB scalability on 24-core box, and we made research of scalability problems in sysbench write workload (benchmark emulates intensive insert/delete queries). By our results the problem is in concurrency on rollback …

Read More
 

Dropping unused indexes

Vadim wrote some time ago about how to find unused indexes with single query. I was working on the system today and found hundreds of unused indexes on dozens of tables so just dropping indexes …

Read More
 

Some little known facts about Innodb Insert Buffer

Despite being standard Innodb feature forever Insert Buffers remains some kind of mysterious thing for a lot of people, so let me try to explain thing a little bit. Innodb uses insert buffer to “cheat” …

Read More
 

Percona welcomes Ryan Lowe and Vladimir Fedorkov

As we’ve said before, the Percona team just keeps growing. This time around, I’m pleased to welcome Ryan and Vladimir.

Ryan Lowe initially joined us from Florida (USA) in June. In his …a consultant, DBA (with Oracle, too!), DBA manager, and programmer makes him a great match for Percona‘s clients. He also contributed some improvements to Wordpress, and he blogs here and on Pablowe.

…and Ryan, a big welcome — we are fortunate indeed you’re working with us. And… go team!

PS: I can’t help but triple-dip, and point out that our own Ewen Fortune has …

Read More
 

Should you move from MyISAM to Innodb ?

There is significant portion of customers which are still using MyISAM when they come to us, so one of the big questions is when it is feasible to move to Innodb and when staying on …

Read More
 

How Percona Develops Open-Source Software

Percona has been building and contributing to open-source software since the company was founded, and individually we’ve been doing the same thing for many years.  We think it’s a huge value for our customers and …

Read More
 

iiBench Contest Updates

We re-ran iiBench based on Mark Callaghan’s excellent work. We used standard InnoDB engine in MySQL 5.1 without the Google or Percona patches. Our hardware is similar to Mark’s except we used a 6-disk hardware …

Read More