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. B+Tree Indexes and InnoDB [//www.slideshare.net/ovaistariq/pluk2011-btreeindexesandinnodb] from Ovais Tariq [https://www.
When EXPLAIN estimates can go wrong!
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 query was totally
Understanding B+tree Indexes and how they Impact Performance
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 work behind the scene and what
Moving on to Percona
Yesterday was my last day at Express News. I have been working here for more than a year now and it has been a pretty good time. I had the opportunity to work with some great people and I am
On Covering Indexes and Their Impact on Performance
The purpose of this post is to describe what covering indexes are and how they can be used to improve the performance of queries. People mostly use indexes to filter or sort the results but not much thought is given
MySQL: Using Views as Performance Improvement Tools
The most basic and most oft-repeated task that a DBA has to accomplish is to look at slow logs and filter out queries that are suboptimal, that consume lots of unnecessary resources and that hence slow down the database server.
On LVM: How to extend Volume Groups and Logical Volumes
In the previous part of this article, we had a look at how to configure LVM, and we had successfully setup a Volume Group and two Logical Volumes. Now we are going to have a look at extending the group
On LVM: How to setup Volume Groups and Logical Volumes.
LVM (Logical Volume Management) is a very important tool to have in the toolkit of a MySQL DBA. It allows you to create and extend logical volumes on the fly. This allows me to, say, add another disk and extend
Subscribe to ovais.tariq - tech and leadership
Subscribe today and get access to a private newsletter and new content every week!