#DBHangOps 08/07/14 -- Spatial Indexes, GTID, and more!
If you missed the hangout, check out the recording below:
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!
- 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: