ZHIYUAN ZANG

SimHash is not suitable for short-text compare.

> > The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different times. For example, if a SELECT is executed twice,...

很久了，大家居然还在讨论。前几天看《MySQL技术内幕-Innodb引擎》里面提到了，MySQL跟标准RR不一样，标准RR存在幻读问题，但innodb通过next-key-lock解决了RR的幻读问题