(Giuseppe Maxia) A devilish quiz by Scott Noyes has made me thinking about a side effect of partitioning.

(Sheeri Cabral) As I putter around the MySQL INFORMATION_SCHEMA, I am finding lots of undocumented behavior for fields that should be straightforward. For example, the VIEWS table holds information about views, and the VIEW_DEFINITION field contains the view definition, right?

(Johan Andersson) In part 1 we got the cluster monitoring up and running. Indeed a good step forward into taming Cluster. This time we are going to add process management to our solution – if a node fails (ndbd, ndb_mgmd, mysqld etc) fails, then it should be automatically restarted.

(Ewen) Recently I was tasked with investigating slippage between master and slave in a standard replication setup.

(Augusto Bott) So you want to store URLs in MySQL, and the URLs have those annoying %20%27%7C%26%5E%2B%2D%25 symbols? And you want to be able to show your users some kind of human-readable information. You might want to consider using this trick.

(Leo Hsu and Regina Obe) There are a lot of functions in PostgreSQL and for the most part, they are nicely tucked away in the pg_catalog schema so they don’t get mixed with your functions. There are a lot of contrib modules though and if you use a few of the big ones and just dump them in the public

(Ronald Bradford) Indexes are a great way to improve performed in a MySQL database, when used appropriately. When used in-appropriately the impact can be a degradation of performance.

(Baron Schwartz) A paginated display is one of the top optimization scenarios we see in the real world. Search results pages, leaderboards, and most-popular lists are good examples. You know the design pattern: display 20 results in some most-relevant order. Show a “next” and “previous” link. And us

(Johan Andersson) Version 1.0 of CMON (gpl license) has now been released. It is dead easy to use and gives you a lot of helpful information about the state of the cluster. Memory utilization, statistics etc.

(Ronald Bradford) Why you do not use GRANT ALL ON *.*? I was with a client today, and after rebooting a MySQL 5.0.22 instance cleanly with /etc/init.d/mysqld service, I observed the following error, because you always check the log file after starting MySQL.