(Baron Schwartz) I haven’t been blogging much about the changes in MySQL for a while. But the MySQL and InnoDB engineers have been doing a ton of work over the last couple years, and now it’s seeing the light of day, so it’s time to offer words of congratulations and appreciation about that.

(depesz) Let’s assume you have some simple database with “articles” – each article can be in many “categories”. And now you want to get list of all articles in given set of categories.

(Quassnoi) Answering questions asked on the site.

(John Russell) It’s been a busy year for MySQL. Perhaps you’ve heard. Here are some recent improvements to the speed, scalability, and user-friendliness of the MySQL database and the InnoDB storage engine that we think deserve their own headlines. Now is a great time to beta test the 5.5 release and

(Baron Schwartz) I’ve heard this question a lot, but never thought to blog about the answer. “Is there a performance difference between putting the JOIN conditions in the ON clause or the WHERE clause in MySQL?”

(depesz) More than once I’ve seen situation when there is a table, with serial primary key, and rows contain also some kind of creation timestamp, which is usually monotonic, or close to monotonic.

(Peter Zaitsev) When replication runs out of sync first question you often ask is if someone could be writing to the slave. Of course there is read_only setting which is good to set in the slave but it is not set always and also users with SUPER privilege bypass it.

(John Dzilvelis) While working on a transformation I ran into a problem with comparing two (seemingly) identical numbers using the Filter Rows step. I had a case where a transformation selected two DECIMAL(13,5) values from the database and compared them.

(Peter Zaitsev) Every so often I am working on the system with custom compiled MySQL. How to upgrade to the new MySQL Options while preserving as much of original compilation options as possible if original build scripts are not available?

(Sean Hull) MySQL has an interesting architecture that sets it apart from some other enterprise database systems. It allows you to plug in different modules to handle storage. What that means to end users is that it is quite flexible, offering an interesting array of different storage engines with