During one of our recent projects, we ran into the classic deadlock between having non-blocking database updates with the ability to perform fulltext searches against our MySQL database.

Let me back up and explain a bit better what I mean. In other words, "let me explain.. no, there is too much. Let me sum up."  read more »