(Giuseppe Maxia) MySQL stored procedures can use SELECT statements in their body, returning a data set to the caller. The manual also explains that multiple data sets can be returned from such a stored procedure.

(Peter Zaitsev) Looking at how people are using COUNT(*) and COUNT(col) it looks like most of them think they are synonyms and just using what they happen to like, while there is substantial difference in performance and even query result.

(Jay Pipes) Robin Schumacher recently gave us an excellent rundown on sessions at the upcoming MySQL Conference and Expo (April 23-26th in Santa Clara) for DBAs. As a proud developer I wanted to make sure that our enormous developer community had a similar guide. Now, developers will encounter the s

(Peter Zaitsev) I just found post by Kevin, in which he criticizes Master-Master approach, finding Master with many slaves more optimal. There is surely room for master-N-slaves systems but I find Master-Master replication much better approach in many cases.

(Jason Gilmore) I’m just a few days away from launching a comprehensive support website for my book, “Beginning PHP and MySQL 5, Second Edition”, and among other features, have built a search engine for sifting through the more than 500 code snippets found throughout the book. This was an interestin

(Kevin Burton) We’ve been working on automatic master promotion for MySQL using lbpool and I’m reminded of a few ideas we had after reading about MMM.

(Xaprb) When I wrote my first article on algorithms to compare and synchronize data between MySQL tables, Webyog’s Rohit Nadhani left a comment on the article mentioning the SQLyog Job Agent, which has a similar function. Although I have been developing MySQL Table Sync essentially in isolation, I h

(Robin Schumacher) One of the great things about MySQL is the superior innovation model that’s used to deliver database server software. Rather than relying solely on internal engineers who create and maintain a piece of software (as in a traditional software company), MySQL partners with the millio

(CrazyToon) One very interesting thing I noticed with MySQL was that if you delete a database, ibdata file doesn’t shrink by that much space to minimize disk usage. I deleted the database and checked usage of /usr/local/mysql/var folder and noticed that ibdata file is still the same size. So the pro

(Xaprb) I wrote an article late last week about benchmark results for the two table-synchronization algorithms I’ve been implementing for the MySQL Table Sync tool. I’ve spent some time developing a test suite for the tool, and learned some really interesting things about the general problem of sync