(Dathan) So, I want to reduce data usage of a text field, by storing unique strings separated by a delimiter.

(Peter Zaitsev) To be honest I’m not a big fan of Stored Procedures, At least not in the form they are currently implemented in MySQL 5.0

(Jorge Bernal) This is my second article about hacking MySQL. If you are interested in this topic, you may want to read my previous Hacking MySQL: SIGNAL support (I)

(Brian Moon) So, I mentioned in my MySQL Cluster post that I found out that cluster and joins don’t get a long too well. There are a couple of tips I have for using joins or replacing them with other techniques that I thought I would share.

(Brian Aker) In our last installment, we looked at how to write data into a storage engine, now lets look at updating it.

(Brian Moon) So, the whole world changed at dealnews when Yahoo! linked us. We realized that our current infrastructure was not scaling very well. We had to make a change.

(Kevin Burton) RAID is dying. Shocked? The prediction might be a bit early for some folks. It’s still somewhat conventional for some people to think that RAID is a conservative way to scale your IO.

(Roland Bouman) There is a popular myth about the SQL GROUP BY clause. The myth holds that ‘standard SQL’ requires columns referenced in the SELECT list of a query to also appear in the GROUP BY clause, unless these columns appear exclusively in an aggregated expression. MySQL is often accused of vi

(Charles Cahoon) The MySQL test framework needs a tool that will increase the production of test cases. The proposed tool will be a command line client that records queries and responses to then create the .test and .result files. There were a couple of proposed options that would also achieve a sim

(Peter Zaitsev) This week I already had two serious performance regression cases when upgrading from MySQL 4.0 and 4.1 to MySQL 5.0. By serious I mean several times performance difference not just 5-10% you often see for simple queries due to generally fatter code.