EmergencyEMERGENCY? Get 24/7 Help Now!

Shard-Query adds parallelism to queries

 | November 15, 2010 |  Posted In: Insight for Developers, MySQL

Preamble: On performance, workload and scalability: MySQL has always been focused on OLTP workloads. In fact, both Percona Server and MySQL 5.5.7rc have numerous performance improvements which benefit workloads that have high concurrency. Typical OLTP workloads feature numerous clients (perhaps hundreds or thousands) each reading and writing small chunks of data. The recent improvements to […]

Read More

Advanced index analysis with mk-index-usage

 | November 11, 2010 |  Posted In: Insight for DBAs, MySQL

The new release of Maatkit has a useful feature in mk-index-usage to help you determine how indexes are used in more flexible ways. The default report just prints out ALTER statements for removing unused indexes, which is nice, but it’s often helpful to ask more sophisticated questions about index usage. I’ll use this blog’s queries […]

Read More

Implementing Parallel Replication in MySQL

 | November 8, 2010 |  Posted In: Insight for DBAs, MySQL

Based on discussions with several clients, we are strongly considering implementing a limited form of parallel replication. Single-threaded replication is one of the most severe limitations in the MySQL server. We have a brief outline of the ideas at this wiki blueprint. So far, the “binlog order” idea is the only one that is workable. […]

Read More

Webinar: MyISAM to InnoDB migration

 | November 8, 2010 |  Posted In: Events and Announcements, MySQL

Register now for a free Percona webinar about migrating your MyISAM databases to InnoDB. Save the date: Dec 1, 2010 at 9:00 AM PST (California) time. Update: the date was originally listed as December 2nd, but that was a mistake. It’s December 1st. We know that not everyone can attend expensive conferences that require travel. […]

Read More

HandlerSocket on SSD

 | November 2, 2010 |  Posted In: Benchmarks

We all enjoyed Yoshinori announcement of HandlerSocket, the plugin to MySQL which open NOSQL way to access data stored in InnoDB. The published results are impressive, but I want to understand some, that’s why I run couple more experiments. In blog post Yoshinori used the case when all data fits into memory, and one of […]

Read More

Baron Schwartz interviewed on WebPulp.tv

 | November 1, 2010 |  Posted In: Events and Announcements, MySQL

There’s an interview with Baron Schwartz (that’s me) on WebPulp.tv. Topics include the history of Percona’s software such as Percona Server (our version of the MySQL database server) and XtraBackup, what we do at Percona, what tools we use to do it, how to think logically about performance optimization, what ugly surprises happen when you […]

Read More