I've finally about finished up 1.2.4. Please give 1.2.4c1 a try. I plan to make the final release next week sometime.

1.2.4 will support Python 2.4, but it's not tested, and won't be supported in 1.3.0. Python 2.5, 2.6, 2.7 and PyPy are all tested and supported.

I still need to make some documentation updates. It turns out I can't easily make it work with Read The Docs since it has a C module, but I'm planning to have them online at packages.python.org.

We have seen number of issues with MySQL Server related to amount of memory you have in the system – these range from problems with large size Query Cache to bad drop table performance with large Innodb Buffer Pool size. As such I wonder how much memory do we really use to run MySQL Server these days ?

Note: There is a poll embedded within this post, please visit the site to participate in this post's poll.

Feel free to select multiple sizes if you have multiple kinds of instances in production and for boundary numbers please select the highest range which applies, ie for 16GB system select 16-64GB range. Thank you for your feedback ! I will keep the pool open until the end of the year when it will be frozen so we do not get results from multiple years mixed.

I’ll speak at the Central Virginia Ruby Enthusiasts group on Nov 13th. The topic is adaptive fault detection in MySQL servers. The techniques apply to any system for which you can measure throughput and concurrency, so come on out and learn how you can get rid of threshold-based monitoring!

Further Reading:

• Central Virginia MySQL Meetup has reached cruising altitude
• New Central Virginia MySQL Meetup
• Speaking at the Shenandoah Ruby Users …

It seems there’s lot of activity in Barcelona, Spain in the coming weeks. Lenz Grimmer talks about speaking at LinuxCon Europe (Nov 5-9), where the conference really runs from Nov 5-7. I’m happy to be speaking about MariaDB on the 5th. Monty Program & SkySQL are joint-booth-sponsors of this event, so expect there to be a presence for Q&A at the booths.

While I wish I can stay on for the meetup organized by …

I was just skimming through the latest “Meet the Experts” podcast from Oracle, whose topic is debugging stored routines in MySQL. The tl;dr (tl;dl?) version is if you’re working with Windows and .NET, you can install a Visual Studio plugin that lets you debug stored routines in the server via the .NET connection libraries. That’s pretty nice, for those who are using that platform. The podcast is only a few minutes, so if you’re interested, by all means listen to it, or take a look at the documentation.

The ideal way to debug stored routines would be an API in the server, but that doesn’t exist. Nevertheless, I remembered having seen some sort-of implementations of debugging at times in the past. My memory was …

I’ll speak at the Central Virginia Ruby Enthusiasts group on Nov 13th. The topic is adaptive fault detection in MySQL servers. The techniques apply to any system for which you can measure throughput and concurrency, so come on out and learn how you can get rid of threshold-based monitoring!

I’ve been doing a little bit of programming in Go recently, and really enjoying it. It’s an awesome language with really solid libraries. It reminds me a lot of the .NET framework in that it’s well-thought-out, but the Go language itself is a lot smaller, less formal, and a lot more expressive than I ever found C# to be. And that’s saying a lot — C# was my previous favorite language, along with the occasional Java, C++, Python, JavaScript, and — gasp — Visual Basic 6. Go beats them all.

But I digress. I’m writing Go applications that talk to MySQL. Some of them talk to the database in read-only ways, and I just wanted to share this neat little nugget about the MyMySQL client libraries (pure-Go implementation; not a wrapper around a C library). One of its features, which you can enable optionally, is autorc. This stands for auto-reconnect to the server. It’s …

A new "Meet the MySQL Experts Podcasts" is available.

Debugging Stored Routines in MySQL with Fernando Gonzalez.

A big thanks to Fernando and the Podcast team at Oracle for helping with this podcast.

November is here and what do we have to be thankful for? A great community overall is the simple answer.

This month looks to have some great MySQL User Group Meetups:

• The Los Angeles PHP Developers Group (LAPHP)
  • Joint LAPHP/LAMySQL meetup. V.Anuganti SQL, NoSQL, Big Data in Data Architecture
    • 7:00PM Thursday, November 1
• The Seattle MySQL Meetup Group
  • The Seattle MySQL Meetup Group Monthly Meetup
    • 7:00PM …

It’s been a while since my post on taking day 1 of this course; as promised, here are my notes and observations after taking Day 2.

First, this is one of the nice things about taking Training on Demand.  I could take Day 1, go about my other business, apply what I learned, etc, then, when ready, take Day 2, even a month or so later!  I was able to go back and review Day 1, then move on to Day 2, entirely at my own schedule.

I remembered something from earlier, and wanted to find it again, so I tried out the search capabilities.  I searched for the phrase I wanted, and up came links to the lessons it appeared in.  I could click on any of the results to view that lesson, and watch, or check the captioning to find the phrase I was looking for.  It worked perfectly!

Day 2 covers data types, basic SELECT queries, and how to create and maintain tables and databases (using DROP and ALTER, and how they …