Posts from — December 2011

Profiling your slow queries using pt-query-digest and some love from Percona Server

This guide will get you up and running with how to identify the bottleneck queries using the excellent tool pt-query-digest. You will learn how to use and analyze the output returned by pt-query-digest. You will also learn some differences between slow query logging in various MySQL versions. Later on in the post I will also show you how to make use of the extra diagnostic data available with Percona Server.

December 28, 2011   Views: 21,787   8 Comments

EC2 firewall and security groups

EC2 includes a security feature that allows you to define groups with a set of firewall rules to restrict access. These groups are called security groups. This post deals with understanding how the security groups work and how to use them to restrict access based on IP as well as roles.

December 27, 2011   Views: 9,160   3 Comments

Slides of my talk on B+Tree Indexes and InnoDB

The slides of my talk on B+Tree Indexes and InnoDB are now available for download. This slide was presented during Percona Live London 2011. You can download the slides from here.
There are many other interesting and informative talks that were presented during Percona Live London 2011, and I think you should definitely check them out, if you haven’t. They are available here.

December 18, 2011   Views: 7,721   1 Comment