Questions tagged [full-text-search]
The full-text-search tag has no usage guidance.
54
questions
0
votes
1
answer
33
views
Full Text Index stuck
We recently upgraded our SQL Server database server.
We have a search on our website that uses a full text index to search.
I am now trying to figure out why the full text index appears to be stuck.
I ...
- 207
0
votes
1
answer
106
views
Find and Replace using Regular Expression
I try to find a way to find and replace using EMEditor and a Regular Expression. I try to applu this for the item below:
<?php
/*f04b8*/
@include "\057mn\164/r\141id\057ho\155e/\164ap\151om\...
- 41
0
votes
1
answer
999
views
How do I configure full-text InnoDb functionality in MariaDB on AWS RDS?
I'm in the process of moving to MariaDB on RDS. My tables are up and running and everything looks good, but given that I'm on MariaDB 10.0.24, I'm considering switching a couple of my MyISAM tables ...
- 113
2
votes
1
answer
428
views
Search strings in text files and show in output the string, preceding one and next one (cmd.exe)
I have a lot of big text files. And I'm searching (within cmd.exe) for a list of values in them as following:
findstr /i /n /g:strings.txt 1\*.* >results.txt
where strings.txt is the file with ...
- 21
1
vote
0
answers
52
views
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 ...
- 1,157
1
vote
0
answers
211
views
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. ...
- 3,620
0
votes
1
answer
131
views
Searching for files containing text (not string) in bash
How do I find files containing some particular text containing newlines and plenty of other charachters all sorts of quotes and backslashes using terminal?
5
votes
2
answers
3k
views
How to stop SQL Server from logging informational lines to SQLFT log files?
I checked on a SQL Server 2012 instance recently only to see that the HDD is full and after investigating what happened it was Full Text Search informational lines filling the log files and disk space ...
- 171
0
votes
2
answers
64
views
Search logs for unique email addresses
I want to search my log-files and only show unique email-addresses that is preceeded by "MAIL FORM:"
For example if I search maybe I got those hits:
Mon 2014-03-17 00:01:38: <-- MAIL FROM:<...
- 197
1
vote
1
answer
2k
views
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 ...
- 41
0
votes
2
answers
294
views
full-text-search on Win SBS 2008 network drive using Win 7 64-bit client
I got a Win SBS 2008 that servers 10 Client machines. 2 of the 10 client machines are running Win 7 64-bit. The other 8 are running Win XP 32-bit. The Win SBS 2008 has a folder which contains bills ...
- 143
0
votes
2
answers
803
views
Exchange 2007 ResetSearchIndex.ps1 time
I am relatively new to exchange. We are running Exchange 2007 sp2 for a medium/large institution and we are having trouble with OWA's search function not working.
I was going to try running ...
- 103
2
votes
0
answers
227
views
Elasticsearch and couchdb river indexing slows down after a few hours
Trying to import ~400m docs in to Elasticsearch from couchdb using the couchdb river plugin. Everything starts out great with indexing time around 5k/s but after a few hours come back and find its ...
- 263
2
votes
1
answer
2k
views
Sphinx searchd: failed to lock .spl file, no such file or directory
I use sphinx for indexing on my development environment, and it is working fine. But when i take it to the server. I can index and I have the indexes with search working on them, but everytime I run ...
- 121
1
vote
1
answer
547
views
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 ...
- 159
1
vote
2
answers
384
views
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 ...
- 3,039
3
votes
3
answers
466
views
Simple full-text search server
I have been looking at search solutions like Sphinx, Solr and Elasticsearch but they are all way too complex for what I need.
I'm basically looking for a server software, best distributed, that ...
- 177
2
votes
0
answers
186
views
Full Text Search query elapsed time varying wildly
Database Version:
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 (...
- 73
1
vote
3
answers
2k
views
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). ...
- 113
0
votes
2
answers
475
views
High MSSEARCH Wait Type in SQL Server 2005
This week I've run into a problem with the MSSEARCH wait type, and I haven't been able to fully diagnose the problem.
The server had been running with no problem for several weeks until the other day,...
- 180
1
vote
1
answer
2k
views
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.
...
- 332
7
votes
1
answer
485
views
Mysql change ft_max_word_len bug
So, I have MySQL installed on my machine, and I need to change the ft_max_word_len, the maximum word length that MySQL will index. However, when I set it up via the tools provided, and query it, it ...
- 231
0
votes
1
answer
177
views
Livelink ECM 9.x. Why Full Text Search Doesn't work for my document
Please explain me how does Full Text Search work in OpenText Livelink ECM?
When I add Microsoft Word document to a folder "Full Text Search" doesn't find it though queried word is the only word in a ...
- 175
2
votes
5
answers
1k
views
Full text search for more than 30,000 MS Office documents [closed]
We have more than 30,000 MS Office and PDF documents in Windows shares on Windows Server 2008 R2. What possibilities do we have to get full text search on all of these documents?
It's important that ...
- 445
1
vote
2
answers
784
views
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 ...
- 111
1
vote
1
answer
179
views
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 ...
- 459
0
votes
1
answer
733
views
Ideas for doing large-scale full-text search on high-insert MSSQL database
I've got a reasonably large MSSQL database with a table of about 6 million rows and around 50k inserts daily. One of the things I'm starting to struggle with is fulltext search, as I've a requirement ...
- 8,050
1
vote
1
answer
386
views
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 ...
- 1,286
1
vote
1
answer
2k
views
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 ...
- 2,711
0
votes
2
answers
1k
views
Failed to install Full-Text Search on SQL Server 2008
I'm trying to upgrade my SQL Server 2008 with Full-Text Search feature. Installation fails on it's very end with something like this in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\...
2
votes
2
answers
2k
views
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 (...
- 1,808
1
vote
2
answers
249
views
Slow Search since moving from 2003 Server to 2008 R2
I moved a client from a old Windows 2003 server to a new fancy Windows 2008 R2 box. I have been able to get everything to work properly except for the search function inside a program called Invoice ...
- 11
2
votes
2
answers
1k
views
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 ...
- 1,989
0
votes
1
answer
171
views
search options based on data
I write an example to be more practive.
I need to know if it is possible to next search based on the data I have in my database, fulltextsearch engines in sqlserver-2008 or Apache Solr:
Case 1:
Data ...
- 209
5
votes
1
answer
3k
views
SQL Full-Text indexing not populating
We installed a clustered SQL 2005 installation on windows 2008 and reattached our san drives from another machine and restored to do a migration to new hardware. There have been a few minor issues, ...
- 2,030
0
votes
2
answers
1k
views
MySQL hangs and table inaccessible after adding fulltext index
After adding a fulltext index to one column in a table with 30,000 rows that table is now inaccessible. Any attempts to modify, drop, truncate, or access it hang. MySQL also reports that the user has ...
- 125
0
votes
1
answer
514
views
How much to increase page file value for SQL Server 2008 R2 Full Text Search Engine
SQL Server 2008 R2 Full-text search engine (FTS) is taking up too much resource (I/O & Memory) in my production server. (migrated from SQL server 2005).
I have been reading up on SQL Server FTS ...
- 2,031
1
vote
1
answer
345
views
Adding features to an SQL Server 2008 standard with SP1
I have MS SQL Server 2008 with SP1 installed.
I want to add the Full text feature to the installation.
Do I need to run the SP1 update again after I add this feature?
If I do try to run it (...
- 75
1
vote
3
answers
986
views
grep/search for multiple lines in a file
Let's say I have a file with a long nested array, that's formatted like this:
array(
'key1' => array(
'val1' => 'val',
'val2' => 'val',
'val3' => 'val',
),
'...
- 391
1
vote
0
answers
484
views
How to create full-text catalog as default catalog?
This would save me the redundant ON MyCatalog phrase when I create full-text indices.
For example,
CREATE FULLTEXT INDEX ON MyTable
(
MyField1,
MyField2,
MyField3
)
KEY INDEX PK_MyKey ON ...
- 855
4
votes
1
answer
8k
views
How to get permission to create full-text index?
I tried to create a full-text index on my new full-text catalog and got this error:
Msg 9967, Level 16, State 1, Line 1
A default full-text catalog does not exist in database 'foo' or user does not ...
- 855
0
votes
1
answer
2k
views
What can cause SQL Server Full Text Indexing automatic change tracking to stop working?
On a SQL Server 2008 server, we have a full text catalog in a database. The catalog is set to "track changes: automatic".
What can cause this to not work sporadically, so the index is not updated?
- 1,059
1
vote
2
answers
15k
views
How do you find the name of an existing full text catalog in SQL Server 2008 Express?
I have SQL Server 2008 Express installed. Several months ago I created a full text catalog and index. I would like to index some additional table columns now, but I can't remember the name of the ...
- 1,039
9
votes
4
answers
8k
views
How do you do a keyword search the Services.msc (mmc) window in Windows 7?
When you want to run a service, you have very limited capabilities, in all current Windows versions, as far as I can tell.
I usually start Services by typing "services.msc" into the Start->Run box, ...
- 1,195
0
votes
1
answer
3k
views
lucene vs sphinx vs xapian vs lemur , which is a good choice for production use? [closed]
I am evaluating the full-text searching systems and I really need your practical experiences. Also you can suggest some that I didn't mention.
- 939
2
votes
2
answers
470
views
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?
- 404
0
votes
1
answer
1k
views
Enabling DB2 Database for Full Text Searching
I'm trying to enable full text searching on a DB2 V9.5 database, SuSe Enterprise Linux.
Net Search Extender has been installed and db2text service starts without problems.
When I execute the ...
- 101
2
votes
2
answers
4k
views
Installing SQL Server 2008 Express Edition with Fulltext Indexing
According to this page, SQL Server 2008 Express Edition with Advanced Services includes Fulltext search:
http://www.microsoft.com/express/sql/download/
However, I downloaded it, ran it, and I see no ...
- 331
2
votes
1
answer
658
views
Full-text catalog timeout, SQL Server 2005
we are re-loading a db with new data using backup/restore process. Once restore is complete, we re-build the full-text catalog. Full text searches work, no timeouts for about a day or so. However if ...
0
votes
1
answer
825
views
How do I modify the thesaurus for full-text-indexing in SQL 2005?
So I've read this:
http://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server/
And I've made the following modification to the tsENU.xml file to include the "...
- 197