Friday, October 31, 2014

Next New York Meeting – Understanding Indexing

For our next meeting we have a guest speaker, Zardosht Kasheff, a frequent attendee at Effective MySQL. He will be talking about “Understanding Indexing”.

Registration Details

Event Date: Tuesday, October 11, 2011, 7:00 PM
Event Location: Hive at 55, 55 Broad Street, 13F,New York, NY 10004

We are switching to using EventBrite for registration. Please register at http://effectivemysql2011oct.eventbrite.com

The cost for event is $5 to cover the event space.

Agenda

  • 7:00 Meet and Greet
  • 7:15 Presentation
  • 8:15 Q & A
  • 8:30 Networking

Presentation Details

Indexes are used to improve query performance. As a result, good indexes are designed around queries that users find important in their application. This talk presents three simple and effective rules on how to construct indexes around queries that result in good performance.

The rules are explained using a simple model that does NOT rely on understanding B-Trees, Fractal trees, or any other data structure used to store the data on disk. They are derived from these simple properties:

  • point queries are slow
  • range queries are fast

Zardosht has been a senior member of Tokutek’s TokuDB engineering team since 2008. Leveraging Fractal Tree Indexing, TokuDB is a high performance storage engine for MySQL that is designed for write-intensive workloads