February 10, 2012

MySQL automatic data truncation can backfire

I had a fun case today. There is set of cache tables which cache certain content in MyISAM tables and queries for these tables such as: select data from cache0003 where `key`=2342526263 and real_key=’cp_140797_6460aad5d2e50d3e859e8649007686ac’; The “key” is CRC32 of the real key which is used to keep index size as small as possible so if [...]

MySQL sources from development tree

I just want to write few tips how to get MySQL from development BitKeeper tree, as there are several tricks. First of all you need a fresh free client – bk-client2.0 http://www.bitkeeper.com/Hosted.Downloading.html . Once you get it, you can clone latest tree: bkf clone bk://mysql.bkbits.net/mysql-5.0 mysql-5.0 New client supports “changes” command, so you can look [...]