Menu ---
  • Home
  • GitHub
  • Contact Me
  • Privacy Policy

ovais.tariq.

opensource tech rumblings

Tag: multi range read

Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5

In MySQL, PerformanceTags indexing, mariadb, mrr, multi range read, mysql, optimizerMarch 21, 20121 Comment ovais.tariq

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 enhancement Multi Range Read (MRR). Its available in both MySQL 5.6 and MariaDB 5.5

Site Sidebar

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 491 other subscribers

Weekly Popular Posts

  • Databases: Normalization... This has really been a long debate as to which approach is more performance orie... 45.29 views per day
  • Understanding B+tree Inde... Indexes are a very important part of databases and are used frequently to speed ... 32.29 views per day
  • Tuning MySQL Server Setti... The default configuration file for MySQL is intended not to use many resources, ... 13.71 views per day

Categories

  • Backups (1)
  • Bugs (2)
  • Chef (2)
  • EC2 (1)
  • High Availability (2)
  • Indexing (6)
  • Innodb (10)
  • Javascript (6)
  • LVM (2)
  • Miscellaneous (4)
  • Monitoring (1)
  • MySQL (35)
  • Performance (16)
  • PHP (5)
  • ProxySQL (1)
  • Replication (4)
  • Security (1)
  • Snippets (6)
  • SSD (1)
  • Web Server (2)

Archives

  • January 2017 (1)
  • February 2016 (1)
  • June 2015 (1)
  • December 2014 (1)
  • November 2014 (2)
  • October 2013 (2)
  • February 2013 (1)
  • October 2012 (1)
  • May 2012 (1)
  • March 2012 (2)
  • December 2011 (3)
  • October 2011 (1)
  • July 2011 (3)
  • May 2011 (5)
  • April 2011 (2)
  • March 2011 (2)
  • February 2011 (1)
  • January 2011 (3)
  • December 2010 (2)
  • November 2010 (4)
  • October 2010 (2)
  • September 2010 (7)
  • August 2010 (3)
  • July 2010 (3)
  • June 2010 (3)
  • May 2010 (1)

Recommended Reading

  • High Scalability
  • MySQL at Facebook's Notes
  • MySQL Dev Zone
  • Percona Database Performance Blog
  • Planet MySQL
  • RocksDB
  • Uber Engineering Blog
  • Web Performance

Site Footer

About Me

About Me

Ovais is a storage architect with keen focus on reliability, efficiency and performance of OLTP databases, more specifically MySQL. He currently works at Uber on ensuring storage reliability and scalability. Previously, he helped different web properties scale their MySQL infrastructure. He also worked at Percona as a Senior MySQL consultant and at a few other startups in various capacities.

Follow me on Twitter

My Tweets

Blogroll

  • DimitriK's (dim) Weblog
  • Domas Mituzas
  • GoogleTechTalks's Channel
  • Marco Tabini
  • Martin Fowler's Bliki
  • Oracle's MySQL Blog
  • Shlomi Noach
  • Small Datum
  • Steve Souders
  • Xaprb