Search issue when using CustomSearch with MySQL Full Text Search as the Index
- Status
- Closed
- Subject
- Search issue when using CustomSearch with MySQL Full Text Search as the Index
- Version
- 12.x
- Category
- Error
- Indexing
- Feature
- Search
Wiki Plugin (extends basic syntax) - Resolution status
- New
- Submitted by
- Pascal St-Jean
- Volunteered to solve
- manivannans
- Lastmod by
- Pascal St-Jean
- Rating
- Related-to
- Description
When using MySQL Full text Search as the index. CustomSeach plugin doesn't seem to find all items as compared to a PHP Lucene index
See show instance
Show username: admin
Show password: 12345- Solution
Some words such as "first" "Second" and "third" are ignored by MySQL search. The info is here: http://dev.mysql.com/doc/refman/5.1/en/fulltext-stopwords.html
I think the solution is simply better documentation.
We need a remarks box as follows: https://www.evernote.com/shard/s37/sh/5cc02209-28e2-4068-8b7c-59bc1d392911/8f68a7e4a3ccddd6ecd1da108345cfa2
It should have the following texts:
MySQL Full Text Search:
- Advantage: Fast performance
- Advantage: Works out of the box with Tiki and even on most basic server setups
- Disadvantage: Many common words (such as "first", "second", and "third" are not searchable). See http://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html for full list
- Disadvantage: Only the first 65,535 characters (about 8000 words) of long pieces of content are searchable.Lucene (PHP implementation):
- Advantage: Overcomes limitations of MySQL search mentioned above
- Advantage: Comes built in with Tiki
- Disadvantage: Slower performance
- Disadvantage: May not work well with the most basic server setups and because the index is stored on disk it is more prone to file permissions problems and other server configuration issues.ElasticSearch
- Advantage: Most advanced and scalable search engine
- Advantage: Enables some very advanced/new features of Tiki
- Disadvantage: Needs to be separately installed from Tiki and requires more configuration (see http://www.elasticsearch.org/ for more information).
I had added a remark box. Please check this commit id: 48338- Importance
- 5
- Easy to solve?
- 5
- Priority
- 25
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 4641
- Created
- Monday 12 August, 2013 13:42:28 UTC
by Pascal St-Jean - LastModif
- Tuesday 12 November, 2013 02:57:01 UTC