EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Server and XtraBackup weekly news, March 19th

 | March 20, 2011 |  Posted In: MySQL, Percona Software

Here’s what is new in Percona Server and Percona XtraBackup since last week. We are working on compiling and checking download statistics for both pieces of software. The preliminary numbers are far higher than I thought they would be. Both Percona Server and XtraBackup are becoming amazingly popular. I am aware of deployments running into […]

Read More

Understanding Indexing – MySQL Meetup

 | March 16, 2011 |  Posted In: Tokutek, TokuView

Yesterday, at the Boston MySQL Meetup, I gave a talk on indexing. It is posted here (also goo.gl/S2LBe). In short, indexes are used to improve query performance. As a result, good indexes are designed around queries that users find important in their application. The presentation covers three simple and effective rules on how to construct […]

Read More

Where does HandlerSocket really save you time?

 | March 16, 2011 |  Posted In: Insight for DBAs, MySQL

HandlerSocket has really generated a lot of interest because of the dual promises of ease-of-use and blazing-fast performance. The performance comes from eliminating CPU consumption. Akira Higuchi’s HandlerSocket presentation from a couple of months back had some really good profile results for libmysql versus libhsclient (starting at slide 15). Somebody in the audience at Percona […]

Read More

Pretty-formatted index fragmentation with xtrabackup

 | March 15, 2011 |  Posted In: MySQL, Percona Software

The xtrabackup compiled C binary (as distinct from XtraBackup, which is the combination of the C binary and the Perl script) has support for printing out stats on InnoDB tables and indexes. This can be useful to examine whether you’d benefit from “defragmenting” your MySQL database with OPTIMIZE TABLE, although I have not determined firm […]

Read More

MySQL on Amazon RDS part 1: insert performance

 | March 15, 2011 |  Posted In: Cloud and NoSQL, MySQL

Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see SSD versus EBS death match), and one of them wanted to evaluate RDS as a replacement. It is built on the same technologies, but the hardware and networking are supposed […]

Read More

Upcoming Webinar on HandlerSocket

 | March 14, 2011 |  Posted In: Cloud and NoSQL, Events and Announcements, MySQL

On March 29th, I’ll be giving a webinar whose title is “Understanding HandlerSocket – A NoSQL PlugIn For MySQL”. This is a continuation and extension of the talk I gave during the Percona Live Event in San Francisco back in February. We’ll ask, and answer, the following questions: What is HandlerSocket? Where does HandlerSocket fit […]

Read More

MySQL Partitioning: A Flow Chart

 | March 11, 2011 |  Posted In: Tokutek, TokuView

In Part 1, and Part 2 of this series, I presented some thoughts on partitioning. I heard some great feedback on why people use partitioning. Here, I present a flow chart that summarizes what I’ve learned. In summary: with TokuDB in the picture there’s almost no reason to use partitioning. Or I should say, there […]

Read More