All posts by Mike Benshoof

A MySQL consultant by trade, a dad, husband and bow hunter the rest of the time...

Operating System Survey

Share on Tumblr

As I start to work through some various tutorials and other instructional guides, I want to get a feel for what people are using.  Please let me know what OS you are currently using and which OS(s) you feel comfortable with.

Ideally, I’m planning to provide a VirtualBox appliance built out with CentOS (linux) that you can run on any machine.  Depending on your comfort level, you can interact with MySQL using:

  • MySQL UI Tools (workbench)
  • VM command line (ssh into VM, then work locally)
  • Local command line client

What Operating System do you use on your own computer/laptop?

View Results

Loading ... Loading ...

What Operating System(s) are you comfortable with?

View Results

Loading ... Loading ...

Check back for a post discussing Virtual Box as it should prove to be a great tool for experimenting with and learning MySQL, regardless of the OS you are used to using.  It will also allow you to experiment, make changes, etc and not worry about impacting your actual system.

February Meetup – MySQL & GIS

Share on Tumblr

When: Wednesday, February 25th @7pm

Where: The404 (details)

At this month’s meetup, I gave a talk about the current (and soon to be GA) geospatial capabilities of MySQL.  The talk covered such things as:

  • High level geospatial overview
  • Early methods of doing geocoding (lat/lon/radius)
  • Intro to GIS functions (geometry type, st_* functions)
  • The impact of adding SPATIAL indexes to InnoDB (coming in 5.7)

My biggest takeaway from prepping for this talk was how excited I am to see SPATIAL indexes for InnoDB in 5.7 (  We ran some sample queries with and without indexes and it showed how InnoDB goes from essentially unusable for GIS programming to a very viable solution.

I can’t wait for 5.7 to be GA!!

As promised, here is a link to the slides:

It was great to see everyone and I’m looking forward to next month!

January Meetup – Big Data

Share on Tumblr

Its almost that time again…

When: Wednesday, January 28th @7pm

Where: The404 (details)

This month, in a slight change of gears, we are talking about everyone’s favorite topic – Big Data.

Our own Kristin Ferrier will be giving a talk about HiveQL (see, I told you we’d talk about complementary technologies) which should serve as a great introduction to Hadoop/Hive.

Along with that, I’ll give a talk (hopefully just drive a larger discussion) about how MySQL fits into the big data ecosystem.  Some topics will include:

  • MySQL strategies for storing big data
  • Leveraging multiple technologies based on use case
  • Developing a hybrid approach to the problem

I hope to see you there and as always, please RSVP at the meetup site here:

Hope to see you there!

December Meetup

Share on Tumblr

Thanks to those that braved a cold rain the week before Christmas for our last meetup of 2014!

Per your requests, I’ve uploaded the slides from the two talks I gave last night – Intro to MySQL Architecture and Basic Query Optimization.  I’ve also attached the initial Intro to MySQL slides as well.

Also, the previously promised intro series is still forthcoming and I’ll likely reference these slides again in various other posts.

I’d like to kick off 2015 strong and one of the suggestions was to work through some typical scenarios that are problematic.  As we move into the new year, I’ll keep you updated as to the January meetup and also get more intro material posted!

Merry Christmas and have a safe and happy New Years!

– Mike

November, 2014 Meetup

Share on Tumblr

Due to the Thanksgiving holiday, we’ve rescheduled the November meeting from the normal 4th Wednesday of the month (which falls on the day before Turkey Day) for Tuesday, November 18th at The404.

This month, Alex Ward will give a talk on some introductory .NET programming using MySQL as a data store.  As .NET is a very popular programming language in the area, this seemed like a great topic to show some of the flexibility and compatibility offered by MySQL.

Please RSVP at the meetup page if you plan to attend so we can get a good count (for food, etc).

Thanks and hope to see you there!