(Robin Schumacher) In Part 1 of this article series, we looked at how the Falcon transactional storage engine was architected and how it compared to some of the other MySQL storage engines. In this article, I’ll focus on how Falcon performs transaction management, including some special points on wh

(Peter Zaitsev) Have you ever seen connection in the SHOW PROCESSLIST output which is in “Sleep” state for a long time and you have no idea why this would happen?

(Melonfire) It’s likely that if you’ve performed a SELECT or UPDATE query in the recent past, you’ve made use of one or more of MySQL’s comparison operators in constraining your query’s output. Comparison is an integral part of most SELECT queries, and MySQL comes with numerous functions for this; a

(Peter Gulutzan) Solid Information Technology (www.soliddb.com / www.solidtech.com) has been around for several years, not in the limelight, but familiar to cognoscenti of the SQL world. Trudy Pelzer and I even visited their office in Helsinki a few years ago; they were all friendly and competent. (

(Xaprb) By reader request, this article explains ways to remove duplicate rows when they are completely identical, and you don’t have a primary key or other criterion to identify which rows to “save.”

(Dan Benjamin) This article is a major update to the older (but tried-and-true) post, Building Ruby, Rails, LightTPD, and MySQL on Tiger. Both Ruby, Rails, and their underlying infrastructure have come a long way in recent months, and this article will get you to a leaner, meaner Rails install in le

(Jay Pipes) OK, so a number of you may have noticed some major gumming up of PlanetMySQL over the last week or so. Some feeds were not appearing at all, and yet other feeds were inserting entries that had nothing to do with MySQL — entries that previously never made it into the PlanetMySQL database.

(Kevin Freitas) I always enjoy trying to do my work creating web applications using the fewest number of database queries possible. It’s kind of a pride thing, I guess. That and I suppose it makes to improve an app’s performance and reduce the load on a server. If you’re into that kind of thing. 😉

(Robin Schumacher) If you’ve been using MySQL for any time at all, you know that a unique advantage afforded MySQL users is the ability to use multiple storage engines to manage the underlying data stored on the server. This efficient and modular architecture provides large performance and manageabi

(Peter Zaitsev) There is one bug, or "missing feature" in MySQL Optimizer which may give you hard time causing performance problems which may be hard to track down, it is using only part of the index when full index can be used or using shorter index while there is longer index available. The last i