Monthly Archives - September 2009

InnoDB/XtraDB Training in New York City!

Our Santa Clara/San Francisco training went great – 100% of survey respondents said they would recommend the same course to a friend.  I’m pleased to announce that such an opportunity exists – our next training location will be New York City on October 30, 2009.
We’ve booked a training venue in the financial district of […]

Read more

Speaking at Highload.ru

This is a quick announcement to say that I’ll be speaking at HighLoad++ this year (October 12-14 in Moscow).  I’ll be presenting on a few topics:

MySQL Performance Tuning (Conference Session)
Quick Wins with Third Party Patches for MySQL (Conference Session)
Performance Optimization for MySQL with InnoDB and XtraDB * (Full day class)

This will mark my first […]

Read more

Attempting to Quantify Fragmentation Effects

We often hear from customers and MySQL experts that fragmentation causes problems such as wasting disk space, increasing backup times, and degrading performance. Typical remedies include periodic “optimize table” or dump and re-load (for example, see Project Golden Gate). Unfortunately, these techniques impact database availability and/or require additional administrative cost and complexity. Tokutek’s Fractal […]

Read more

How to generate per-database traffic statistics using mk-query-digest

We often encounter customers who have partitioned their applications among a number of databases within the same instance of MySQL (think application service providers who have a separate database per customer organization … or wordpress-mu type of apps). For example, take the following single MySQL instance with multiple (identical) databases:
(more…)

Read more