Ovaistariq - ovaistariq.net - ovais.tariq
General Information:
Latest News:
Implications of Metadata Locking Changes in MySQL 5.5 9 Feb 2013 | 10:52 pm
While most of the talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), I have had lately some very interesting cases to deal with, with respect to the Metada...
On SSDs – Lifespans, Health Measurement and RAID 11 Oct 2012 | 05:54 pm
Solid State Drive (SSD) have made it big and have made their way not only in desktop computing but also in mission-critical servers. SSDs have proved to be a break-through in IO performance and leave ...
Join Optimizations in MySQL 5.6 and MariaDB 5.5 31 May 2012 | 08:24 pm
This is the third blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is targeted at the join related optimiz...
Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5 22 Mar 2012 | 03:30 am
I have written a second blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is aimed at the optimizer enhance...
Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact 13 Mar 2012 | 08:37 pm
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one...
Profiling your slow queries using pt-query-digest and some love from Percona Server 29 Dec 2011 | 02:23 am
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-diges...
EC2 firewall and security groups 27 Dec 2011 | 10:11 pm
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 se...
Slides of my talk on B+Tree Indexes and InnoDB 18 Dec 2011 | 09:58 pm
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...
When EXPLAIN estimates can go wrong! 17 Oct 2011 | 07:32 am
This is the title of my first blog post on MySQL Performance Blog. It deals with a customer case where the customer was facing a peculiar problem where the rows column in the EXPLAIN output of the que...
Understanding B+tree Indexes and how they Impact Performance 14 Jul 2011 | 10:03 pm
Indexes are a very important part of databases and are used frequently to speed up access to particular data item or items. So before working with indexes, it is important to understand how indexes wo...
