Updated Forum Search Index Min Word Length to 2 Chars and Added Quick Search Bar

Tags
bar, discussions, ft_min_word_len, fulltext search, index, length, mysql, search

Login to Reply

 
Thread Tools Search this Thread
# 1  
Old 1 Week Ago
Updated Forum Search Index Min Word Length to 2 Chars and Added Quick Search Bar

Today I changed the forum mysql database to permit 2 letter searches:

Code:
[mysqld]
ft_min_word_len=2

I rebuilt the mysql search indexes as well.

Then, I added a "quick search bar" at the top of each page.

I have tested this and two letter searches are working; but it's not perfect, because special characters like dashes seem to not count toward the word length.

This means, for example, these searches work:

Code:
grep -vi
ps -ef

However, these searches fail:

Code:
grep -v
grep -i
netstat -a

If anyone is an expert in MySQL and knows how to get around this limitation without setting the min word length to one, please let me know. I'm not inclined to set the fulltext search index to a minimum word length of one.

Cheers.
# 2  
Old 1 Week Ago
Update:

I had to change this back to three because the load was killing the server:

Code:
[mysqld]
ft_min_word_len=3

Sorry, our database is too large for ft_min_word_len=2.

That was a disaster. The load average shot up to over 50 and was averaging around 40 after making the change. Now it is back to normal (less than 2).

On the other hand, the indexes were build with ft_min_word_len=2 so they seem to still work at the moment.
Login to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Similar Threads More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Updated Forum Search Index Min Word Length (Again) Neo What is on Your Mind? 1 4 Weeks Ago 02:34 AM
awk search for max and min while ignoring special character ncwxpanther Shell Programming and Scripting 7 07-29-2015 02:41 PM
How to search for a string with special chars? santokal UNIX for Dummies Questions & Answers 8 02-19-2014 06:37 PM
awk Search Array Element Return Index u20sr Shell Programming and Scripting 11 12-10-2013 10:38 AM
awk : search last index in specific column tarun.trehan Shell Programming and Scripting 17 11-18-2013 12:45 PM
Search an array and return index (bash) RMontenegro Shell Programming and Scripting 5 11-09-2011 04:15 PM
how to search array and print index in ksh tmalik79 Shell Programming and Scripting 1 09-28-2011 01:13 PM
quick question vi word search hobiwhenuknowme UNIX for Dummies Questions & Answers 1 09-20-2010 05:31 PM
Awk search for max and min field values Kirichiko UNIX for Dummies Questions & Answers 3 07-29-2008 05:43 PM
All times are GMT -4. The time now is 06:06 AM.

Unix & Linux Forums Content Copyright 1993-2018. All Rights Reserved.