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

ovais.tariq.

opensource tech rumblings

Tag: alter

Implications of Metadata Locking Changes in MySQL 5.5

In MySQLTags alter, ddl, locking, mdl, metadata locking, mysql, mysql 5.1, mysql 5.5, transactionsFebruary 9, 20137 Comments ovais.tariq

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 Metadata Locking related changes that were introduced in MySQL 5.5.3. It appears that the implications of Metadata Locking have not been covered well, and since there are still a large number of MySQL 5.0 and 5.1 installations that would upgrade or are in the process …

Continue Reading

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.43 views per day
  • Understanding B+tree Inde... Indexes are a very important part of databases and are used frequently to speed ... 32.43 views per day
  • Tuning MySQL Server Setti... The default configuration file for MySQL is intended not to use many resources, ... 13.86 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