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 [http://www.percona.com/live/mysql-conference-2012/sessions/mysql-optimizer-standoff-mysql-56-and-mariadb-53] . This blog
A collection of 31 posts
Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
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. So in the same
Profiling your slow queries using pt-query-digest and some love from Percona Server
Overview Profiling, analyzing and then fixing slow queries is likely the most oft-repeated part of a job of a DBA. And there are not too many tools out there that can make your life easy by providing analysis of queries
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. 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
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.
Understanding MySQL binary and non-binary string data types
There are two main categories of string data types available and understanding their characteristics properly will allow you to choose the appropriate string data type for the column in accordance with the requirements of the application. Having reviewed different table
A few notes on locking in MySQL
This is another article in a series of articles titled “A few notes …” in which I will be posting some important information about locking concepts, different types of locks and what locks table engines support. Just like the previous article,
Subscribe to ovais.tariq - tech and leadership
Subscribe today and get access to a private newsletter and new content every week!