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


 
Thread Tools Search this Thread
The Lounge What is on Your Mind? Updated Forum Search Index Min Word Length to 2 Chars and Added Quick Search Bar
# 1  
Old 12-08-2018
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 12-08-2018
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 or Register to Ask a Question

Previous Thread | Next Thread

4 More Discussions You Might Find Interesting

1. What is on Your Mind?

Updated Forum Search Index Min Word Length (Again)

For some reason, three char word lengths were not showing up in search results, even though the minimum is set to three and has been for a long time. After monkeying around with this, I turned off full page search, dumped all search indexes, and re-enabled full text search and it's working... (1 Reply)
Discussion started by: Neo
1 Replies

2. UNIX for Dummies Questions & Answers

How to search for a string with special chars?

Hi guys, I am trying to find the following string in a file, but I always get pattern not found error, not sure what is missing here. Can you help please? I do a less to open the xrates.log and then do a /'="18"' in the file and tried various combinations to search the below string. String... (8 Replies)
Discussion started by: santokal
8 Replies

3. UNIX for Dummies Questions & Answers

quick question vi word search

hi, while in vi, we use /string to look for the particular string. after that operation, the particular string is highlighted in yellow color. how do i take the highlight off? thanks so much. (1 Reply)
Discussion started by: hobiwhenuknowme
1 Replies

4. UNIX for Dummies Questions & Answers

Awk search for max and min field values

hi, i have an awk script and I managed to figure out how to search the max value but Im having difficulty in searching for the min field value. BEGIN {FS=","; max=0} NF == 7 {if (max < $6) max = $6;} END { print man, min} where $6 is the column of a field separated by a comma (3 Replies)
Discussion started by: Kirichiko
3 Replies
Login or Register to Ask a Question