June 18, 2013

Post: Sphinx: Going Beyond full text search

… pointing to. So “mysql.com” links were stored in one table group and “google.co.uk” on another. We still had… and we did not want to go into creating all this data as summary tables. Instead we decided to use Sphinx for… them in this case as we’re doing kind of “boolean full text search”. Plus we can make index built sorted…

Post: Announcing Percona Server 5.1.66-14.1

… SYS_STATS table was corrupted or overwritten. This is now fixed by detecting the corruption and creating a new SYS_STATS table. Bug… flashcache was not used. This was fixed by adding new boolean option flashcache. When set to 0 (default), flashcache checks are… compiled with a non-default maximum number of indexes per table. Upstream MySQL bugs fixed: #54127, #61178, #61179 and #61180. Bug…

Comment: Full text search for all MySQL Storage Engines

…. It wouldn’t be too hard to use a MyISAM table just for search, and keep the information via rules (functions… searching multiple FT indices is NOT to do so, and create a table or column that puts all the information together. Unfortunately… helps someone. Also, reasonable results can be achieved by using BOOLEAN queries to restrict, and expressions to sort. AFAIK, natural FTS…