'Index' Tag

• What is this MySQL file used for?

  February 16, 2011

  MySQL keeps many different files, some contain real data, some contain meta data. Witch ones are important? Witch can your throw away? This is my attempt to create a quick reference of all the files used by MySQL, whats in them, what can you do if they are missing, what can you do with them. [...]

  posted in Tips & Tricks by mark

• MySQL GIS – Part 4

  September 21, 2010

  WHAT CAN YOU DO WITH GEO DATA? Geo spatial indexes are what make this type of data valuable.  With shape and point data you can find relationships between object in our physical world.  How close is the lightning in the storm front?  What homes where hailed on? (WDT) What schools are in my city?  With a [...]

  posted in GIS by mark

• Loading Bulk CSV Tables

  March 23, 2010

  In my job I use many data tables that are transient.  New weather data is received all the time and old data is purged.  Most of these table are received as CSV files.  The data is then loaded into MySQL tables and indexed to be used with geographic queries. Most of these tables never see [...]

  posted in Tips & Tricks by mark