Entries Tagged as 'databases'

Sunday, February 24th, 2008

Inside MySQL

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 caches only key [...]

Tuesday, February 12th, 2008

Full-Text Search in MySql and the Minimum Indexed Word Length

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 change [...]