MySQL Forums
Forum List  »  Full-Text Search

Different results on local PC and server
Posted by: Mike Tishetsky
Date: May 29, 2005 03:03AM

What I have:
1. Mysql 4.1.11 on local computer, Mysql 4.0.24 on my server
2. Identical databases on both computers

When I perform fulltext search in a way like folowing:

select * from program where match (name, keywords, description) against ('+3gp* +converter*' in boolean mode)

the result on local machine is quite different from the result on server - server version does not include some records. Cannot understand why. I suppose that fulltext indexing in 4.0 and 4.1 cannot be so much different. Will greatly appreciate any advice.

Also I can assume that some parameters in my.cnf differ for local and server version that may cause such behavior, but cannot even predict which ones. - Download programs found by keyword instead of browsing categories.

Options: ReplyQuote

Written By
Different results on local PC and server
May 29, 2005 03:03AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.