Talk shop and learn about MySQL and occasionally some other stores!

Topics and RecordingsLearn From Previous Discussions!

How to JoinSome simple setup help!

Follow Us On


#DBHangOps 08/07/14 -- Spatial Indexes, GTID, and more!

If you missed the hangout, check out the recording below:

Hello everybody!

Join us at #DBHangOps this Thursday, August, 07, 2014 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

  • Spatial Indexes with Matt Lord
    • What they are
    • How they work
    • When to use them
  • GTIDs in MariaDB
  • Upcoming InnoDB Data Dictionary changes

Be sure to check out the #DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the google hangout on Thursday!

See all of you on Thursday!

Show notes

Spatial Indexes

  • http://en.wikipedia.org/wiki/R-tree covers a good example of R-Trees which are used to store SPATIAL index data
  • Spatial data is typically thought of in GIS contexts for dealing with Map data of the earth, but it can be used for all types of data
  • You would use this to store "spatial attributes" of points (e.g. a park on a map, a building, etc.)
  • Effectively running range queries that finds geometries that fit in a bounding box
  • MySQL 5.7 will be bringing in spatial index support for InnoDB!
    • Prior to MySQL 5.7 you either had to use MyISAM or accept no indexing in InnoDB

Additional Spatial Querying/Indexing Resources: