Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [full-text-search]

53 questions
2
votes
2 answers

Why is this MySQL FULLTEXT query returning 0 rows when matching rows are present?

I have a MySQL 5.5.4 table with >200M rows which has a FULLTEXT index on two columns (Title,Body). When I do a simple FULLTEXT query in the default NATURAL LANGUAGE mode for some popular results (they'd return 2M+ rows), I'm getting zero rows…
Don MacAskill
  • 1,808
  • 3
  • 16
  • 22
2
votes
2 answers

SQL Server Full Text Search resource consumption

When SQL Server builds a fulltext index computer resources are consumed (IO/Memory/CPU) Similarly when you perform full text searches, resources are consumed. How can I get a gauge over a 24 hour period of the exact amount of CPU and…
Sam Saffron
  • 1,979
  • 3
  • 18
  • 27
2
votes
2 answers

What is the big difference between Fulltext-Search on SQL2000 and SQL2008

my first test to get a given database with activated fulltextsearch running on a sql2008 failed with the result that it creeps. sql2008 took several the time of sql2000, but why?
Ice
  • 404
  • 1
  • 7
  • 16
1
vote
0 answers

Does Exchange Multi-Mailbox Search Generate Logs?

Does Microsoft Exchange generate any logs when a Multi-Mailbox Search is performed, or otherwise create any type of audit record? I have a need to review the times, dates, and search terms for any past Multi-Mailbox Searches. Additionally, is…
Will
  • 1,147
  • 10
  • 26
1
vote
0 answers

How to configure a PostgreSQL GIN index to support partial matches

I'm currently using a GIN index to do lightening fast full text search queries in PostgreSQL. It works great, with the only exception being it doesn't seem to handle partial-word searches. e.g. Searching for "bob joe" can find the record containing…
Cerin
  • 3,600
  • 19
  • 61
  • 79
1
vote
2 answers

MySQL Fulltext 3 letter limit

We have a site thats using MySQL fulltext searching but has an issue that a number of strings that need to be indexed are 3 characters long. I know that the default for MySQL is not to index strings of this length but I also know that it is possible…
robjmills
  • 990
  • 9
  • 26
1
vote
1 answer

full text search and date field

I have problem with full text search for one application. I cannot search for dates for a field that is defined as date/time. The full text search dialog for Condition "By field" and the field in question give us the option "contains/does not…
kasper_341
  • 41
  • 5
1
vote
1 answer

Is there any way to store the index of a network file system (SMB 2.0) on the server, so that my users don't have to manually set up the index?

I apologize if this is in the wrong place, but I believe it is sufficiently server related. Also, just as a disclaimer: I'm not the server guy! I'm just trying to find out information. I have several GB of PDF documents that I need to provide to my…
Pandincus
  • 159
  • 1
  • 4
1
vote
2 answers

Add a web based document search to my debian fileserver

I have a Samba-based fileserver with lots of gigs of data on it, mostly Word, Excel, OpenOffice and PDF documents. I've set up a simple web based search interface (Apache, PHP, mlocate) that just goes on filepaths + mtime. It works, for that, but it…
artfulrobot
  • 2,949
  • 13
  • 36
  • 60
1
vote
3 answers

Mysql full text search cause high usage CPU

We built a news site. Every day we will input tens of thousands data from web api. In order to provide a precision search service, our table use MyISAM, build fulltext index (title, content, date). Our site now test in Godaddy VDS with 2GB RAM,…
Giberno
  • 113
  • 6
1
vote
1 answer

MySQL - Changing FT_MIN_WORD_LEN (my.ini)

I've recently asked my server administrator, for my Windows dedicated server, to change the MySQL configuration file (my.cnf) to allow search words of 2 characters or more, from the default of 4. They said they have changed it, restarted MySQL and…
PaparazzoKid
  • 332
  • 1
  • 3
  • 15
1
vote
2 answers

MySQL and cardinality of index

I have a MyISAM table in a MySQL database on an Ubuntu 10.04 server with 256mb RAM. Maximum packet size is 32mb. The table has 150,000 rows. The table has three columns, two of which are TEXT type. I create a FULLTEXT index on both of these; one…
SK9
  • 111
  • 4
1
vote
1 answer

MySQL deadlocks when trying to drop large fulltext index

I'm trying to just drop a 500mb fulltext index on an older 4.1 MySQL MyISAM table. When I do it, the cpu pegs to 100% and sits like that for over 10 minutes. This cannot be normal, right? I gave up and just restarted mysql and index is still…
ck_
  • 459
  • 1
  • 7
  • 20
1
vote
1 answer

Windows Search Service causing too many accessed files

I am trying to more closely audit my users access of files located on a file share. The files share is served by a server running windows server 2008 R2 and running the Windows Search Service. I am having a problem with too many Event 4663's ("An…
SLY
  • 1,286
  • 1
  • 13
  • 28
1
vote
1 answer

How to add full text feature to already installed SQL Server Express 2008

I have an installed version of SQL Server Express 2008 but it does not have the full-text service. Short of uninstalling and re-installing the Advanced Services version, what is the easiest way to add the full-text feature?
user35042
  • 2,681
  • 12
  • 34
  • 60
1
2
3 4