(Andrew Hutchings) One of the most common errors we come across whilst supporting MySQL Cluster is an error commonly referred to as ‘GCP stop’. These errors will occur most frequently in cluster setups which have high activity and more often than not use disk data. So lets look into what these are

(Scott Noyes) So you have two versions of a database sitting around – maybe you’ve been trying things out on your development box, and now you want to move it all over to production. If it’s just a new table here and an extra column there, you could do it by hand, but if you’ve made lots of changes,

(Chris Calender) Have you ever wanted a handy reference of all of the various variables available in MySQL Proxy?

(Sheeri K. Cabral) Ronald Bradford’s recent warning to be sure to know your my.cnf sections reminded me of a similar issue that I ran into last summer, where putting the “group” option in both the [mysqld_safe] and [mysqld] directives resulted in a mostly silent problem.

(Ronald Bradford) The MySQL configuration file, e.g. /etc/my.cnf has a number of different section headings including [mysql], [mysqld], [mysqld_safe]. It is important that you ensure you put the right variables into the right section. For example, the following my.cnf configuration file will not op

(Justin Swanhart) I’ve been using the MonAMI MySQL metrics collection plugin with some minor modifications to collect metrics from MySQL database servers. The plugin collects metrics using “SHOW GLOBAL STATUS” and using the INFORMATION_SCHEMA. The MySQL plugin can be used to write the metrics into a

(Vincent Danen) When it comes to open source databases, MySQL gets the lion’s share of attention. MySQL is an easy-to-use database, and a lot of open source Web applications are geared towards it. The other primary open source database is PostgreSQL which, while widely known, doesn’t have the same m

(Marc Alff) This paper is an introduction to the new ‘performance schema’ feature, which will be part of the upcoming MySQL 5.5 release. Covering in details every part of the performance schema would require much, much more than a simple article. The pace of this teaser is voluntarily fast, to have

(Mark Callaghan) When incrementing a table that manages a count are you an optimist or a pessimist? If the row is likely to exist, you should first try to update it and do an insert when the update fails. Otherwise, use insert … on duplicate key udpate.

(Morgan Tocker) A while back Friendfeed posted a blog post explaining how they changed from storing data in MySQL columns to serializing data and just storing it inside TEXT/BLOB columns. It seems that since then, the technique has gotten more popular with Ruby gems now around to do this for you aut