On the way to perfect computing

Majority of us knows that databases are read-optimized products and most of them are not optimized for writes. In this post I would like to describe what’s going on under the hood of mysql that can help us to find origins of some well-known rules. So, let’s start with MySQL MyIsam table: – MyIsam tables [...]

MySql comes with extremely useful feature full-text search. The minor thing that bored me was the minimum word length that mysql can index to. It was 4 letters by default on my machine. To change the value to desired one you need to: set ft_min_word_len variable up in my.ini file restart mysql ensure that the [...]