CACTUSS

Capital Area Central Texas User of SQL Server

Austin, TX chapter of PASS

Contact us: Email: CACTUSS.SQL (at) (gmail) (dot) (com)
Twitter:@CACTUSS_SQL
LinkedIn:https://www.linkedin.com/groups/149440
Meetup:https://www.meetup.com/Austin-SQL-Server-User-Group/

Upcoming Meeting Dates

  North South
Jan
2017
Tue 1/17/2017
Speaker: John Sterrett
Topic: Understanding Locking from Distributed Systems
Wed 1/18/2017
Speaker: Chris McGowan
Topic: MyMVCC, Multiversion Concurrency Control
Feb
2017
Tue 2/21/2017
Speaker: Sean McCown
Topic: The Backup Tune-up for Speed
Wed 2/15/2017
Speaker: OPEN - Submit your own presentation to give
Topic: TBD
Mar
2017
Tue 3/21/2017
Speaker: OPEN - Submit your own presentation to give
Topic: TBD
Wed 3/15/2017
Speaker: OPEN - Submit your own presentation to give
Topic: TBD
Apr
2017
Tue 4/18/2017
Speaker: OPEN - Submit your own presentation to give
Topic: TBD
Wed 4/19/2017
Speaker: OPEN - Submit your own presentation to give
Topic: TBD

 


Meeting Locations

CACTUSS North

  • Meeting dates: 3rd Tuesday of the month
  • Meeting starts: 6:00 pm with food and a QA session
  • Presentation: 6:30 pm and goes to 7:30 pm
  • Address
    • Quarry Oaks II
    • 10900 Stonelake Blvd., Suite 225
    • Austin, TX 78759
      • * Free parking
      • * Coming from Braker, go right/straight at the traffic circle and it's the building on the left.
      • * The building is also across from the outdoor basketball court
      • * Not the building attached to the parking garage
      • * Inside the Microsoft office, go right, past the reception desk, to the far back and left
      • * If there is interest, there is sometimes an after-gathering at a local place to talk casually
    • Map: http://binged.it/1HOSMWm

CACTUSS South

  • Meeting dates: 3rd Wednesday of the month
  • Meeting starts: 6:00 pm with food and a QA session
  • Presentation: 6:30 pm and goes to just after 7:30 pm (We don't have as much of a time constraint here)
  • Address
    • Pleasant Hill Public Library
    • 211 E. William Cannon Drive
    • Austin, TX, 78745 William Cannon just West of IH-35
      • * Free parking
      • * In the meeting room to the back left, down the hallway
  • Map: http://binged.it/1PEvhCS

Next Meeting

Wednesday,

January

18

SOUTH
MyMVCC, Multiversion Concurrency Control
Chris McGowan

211 E. William Cannon Drive
Austin, Texas 78745
Time: 18:00 - 19:30

Title: MyMVCC, Multiversion Concurrency Control
by: Chris McGowan

Summary:

The nature of MVCC reflects a desire to leverage an optimistic concurrency handling strategy without sacrificing consistency. It is the heart of the I in ACID, that is to say, “Isolation”, for an RDBMS. The alternative to achieve consistency is pessimistic locking, which can even be more efficient in cases where the odds of concurrent success in isolation are low (the symptom of this case being frequent deadlocks).

Since most OLTP workloads are working on sufficiently different scopes of data, the optimistic strategy (at the row level) tends to yield better capacity for concurrency, and has therefore become a nearly ubiquitous feature of the modern RDBMS. Understanding the mechanisms of each engine’s MVCC, therefore, gives us an advantage in eliminating more cases that favor the pessimistic strategy.

The goal of this presentation is to brief the attendee on:

  • The coverage of MVCCs (or lack thereof) offered by the most common MySQL storage engines.
  • The gotchas implied by these.
  • Schema modeling strategies to leverage the mechanisms that these MVCC systems employ, and maximize performant options at query time.

Speaker: Chris McGowan:
Bio: None

Special Notes:

 

Available Attachments: