The other day, a client mentioned they were getting strange results when running ALTER TABLE. The episode involved modifying an existing primary key to add an auto_increment primary key: it was “shifting” values. Say what?! As it turns out, it was a very special value getting changed: zero. Some fiddling revealed the underlying reason. Care to join me? To understand what’s going on, follow the example below as we start with an empty database, create a table and insert a few rows
Last week I had to confront one of those situations where you can’t really tell what is going on with a piece of software, and the final conclusion would sound completely crazy if postulated as the initial hypothesis. The regular MySQL commands and utilities fall short in these cases, so I had to resort to the three tools reviewed in this article.
We are planning the winter issue of MySQL Magazine. With the new GA release of MySQL server 5.1 last month, there is certainly plenty to talk about!
You can reach me with your ideas at firstname.lastname@example.org . I need to see all article proposals by the 15th of this month. Draft articles must be in by the 10th of January, so if I accept your proposal, you have a month to get things ready.
I think it would be wonderful to learn about the various technologies (including MySQL) used and challenges faced by folks “behind the scenes” at barackobama.com (and now change.gov), since they have to keep in mind the high rate of burstiness, and of course how to scale not just for the peaks but for generally higher demand for longer periods of time, like the week before the election occurred.
The term “binary” in MySQL has many different meanings. How many can you come up with? I have 6, but I am willing to believe there are more! Here they are…
Brian Aker delivers the keynote speech at OpenSQL Camp: State of the Open Source Databases. The presentation begins with a disclaimer:
“There is no way I’m going to tell you exactly where the future of databases go. We have way too many egos in the room to ever even begin a discussion…” and ends with Aker saying, “What the hell does that mean?” There’s a link to the video here.
The MySQL 5.1 GA Release will be on or about Dec. 6th, 2008. How do I know?
OpenSQL Camp is in full swing! Baron Schwartz has done an amazing job organizing this free unconference. We are well into the 2nd session of the day, and the quality of the presentations is excellent (though I expected that!) and it is always great to see people.
Lots of interesting talk, mainly MySQL related, and lots of food, just like it should be. There were some pictures taken, but I’ve yet to see them online, but keep watching Planet MySQL and I’m sure you’ll see them.
At LISA 2008, I gave a presentation entitled “How to Stop Hating MySQL: Fixing Common Mistakes and Myths”. The video and presentation slides are available here.