EmergencyEMERGENCY? Get 24/7 Help Now!

A quest for the full InnoDB status

 | October 31, 2008 |  Posted In: Insight for DBAs

When running InnoDB you are able to dig into the engine internals, look at various gauges and counters, see past deadlocks and the list of all open transactions. This is in your reach with one simple command —

. On most occasions it works beautifully. The problems appear when you have a large spike in […]

Read More

Speaking on MySQL SF Meetup (Nov 3)

 | October 27, 2008 |  Posted In: Events and Announcements

November 3rd, I’m speaking at San Francisco MySQL Meetup – The talk will be about Scaling MySQL driven Web Sites by Sharding and Replication. This is Free event and you’re surely most welcome to join. At this point I see there are some 70 people signed up and 59 spots left. BTW: This will not […]

Read More

Mirrored Binlogs patch

 | October 25, 2008 |  Posted In: Percona Software

Google patches V1 contain interesting patch to mirror binary log on slave. Although Google is preparing GlobalTransactionId patch, which going to be replacement for MirroredBinlogs, we still think mirroring binary logs is very useful for: Backup of binary logs in real time High availability, to switch master load to slave with mirrored binary logs By […]

Read More

JOIN Performance & Charsets

 | October 21, 2008 | 

We have written before about the importance of using numeric types as keys, but maybe you’ve inherited a schema that you can’t change or have chosen string types as keys for a specific reason. Either way, the character sets used on joined columns can have a significant impact on the performance of your queries. Take […]

Read More

Improved InnoDB rw_lock patch

 | October 20, 2008 |  Posted In: Percona Software

There is patch from Google to improve SMP performance , but for some workloads it showed for us reverse scalability. E.g. update_key benchmark from sysbench. There are also results with Yasufumi’s rw_locks (http://bugs.mysql.com/bug.php?id=26442)

Read More

Percona’s patches spread to a wider audience

 | October 13, 2008 |  Posted In: Percona Software

Percona’s patches are now available to a wider audience via OurDelta, a community effort to provide  builds with features (Percona patches, Google patches, etc) and storage engines (PBXT, Sphinx, etc) that aren’t in the main MySQL server. Arjen Lentz is really the brainchild behind this. Kudos Arjen! What does this mean for the Percona patches? […]

Read More

Percona welcomes Ewen Fortune and Piotr Biel

 | October 1, 2008 |  Posted In: Events and Announcements

Although we haven’t announced any new members in a while, the Percona team has continued to grow steadily behind the scenes. Our hiring policy is to have a few months’ provisional period to ensure the…, of course. Ewen has been a consultant and contractor before joining Percona, and has many years of experience in Oracle, MySQL, Unix systems ….

Piotr Biel lives in Poland, quite close to our other Polish team member (Maciek Dobrzanski). In his past as a system architect he … can do!

Ewen and Piotr, a very warm welcome to the Percona team from all of us, and we are so glad to …

Read More