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!
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!
In a step back from previous meetings, we’ll shift the focus to introductory topics about MySQL. Much of the feedback that I’ve gotten is that while some of the more advanced discussion is good, there is a desire for more basic information.
With that in mind, the October Meetup will be just that – an Intro to MySQL. Some of the topics will include:
- General database concepts
- What is MySQL?
- How is it used?
- How can I get started with it?
I’ll also include a demo showing a MySQL installation on Windows for those that may not be comfortable diving right into Linux.
As usual, food will be provided and we’ll be raffling off a copy of High Performance MySQL (courtesy of Percona) as well! Please RSVP as well so we can get an accurate count for food.
Hope to see you there!
Building on the enthusiasm and topic from the first meetup, I’m pleased to announce the August meeting on August 27th at 7pm at The 404. This months meeting will build on July’s topic of indexing strategy by showing some real-world application.
Dave Stokes, Community Manager from Oracle and former MySQL Certification Manager for MySQL AB and SUN will discuss how to use EXPLAIN to optimize queries that are shown to be sub-optimal. This is a very common task for MySQL DBAs and also a good practice for developers (DBAs love it when their developers think about query execution prior to code being deployed).
I’ll also give a brief talk on how you can collect traffic from a production system and isolate problem queries. More often than not, bad queries are the source of server problems so identifying and optimizing them is key to keeping your database running optimally.
Like last time, we’ll be providing pizza, drinks, and snacks – hope to see you there!
I’m pleased to announce that the first meet-up of the OKC MySQL User Group will take place on July 23rd at 7pm in the Oklahoma City Film District at the Paramount OKC. For the initial meeting, I wanted to bring in a guest speaker to help generate some extra excitement. I think our first guest should do just that…
Peter Zaitsev, co-author of High Performance MySQL and CEO of Percona was kind enough to offer his time to give a presentation covering “MySQL – Indexing Best Practices”, followed by a question and answer session. This is a great opportunity for anyone interested in MySQL to hear from one of the household names in the community!
We’ll be providing pizza and drinks (courtesy of Percona) and will also be raffling off some additional items, including a pass to the 2015 Percona Live MySQL Conference and Expo in Santa Clara.
Please spread the word to anyone and everyone in the industry and I look forward to seeing you at our first event!