Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
86 views

Optimize performance of subs_filter or LUA gsub on Nginx for large streams

I need to make multiple substitutions on a page, served via Nginx. I know that standard sub_filter module doesn't work here, because is limited to a single substitution. So, I came up with two ...
0
votes
2answers
46 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 ...
1
vote
1answer
302 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 ...
0
votes
1answer
134 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 ...
0
votes
2answers
311 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 ...
1
vote
0answers
142 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 ...
2
votes
0answers
334 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 ...
0
votes
1answer
86 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 ...
0
votes
1answer
169 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
votes
3answers
315 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 ...
2
votes
0answers
136 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 ...
0
votes
3answers
754 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). ...
0
votes
2answers
299 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 ...
1
vote
1answer
719 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. ...
7
votes
1answer
330 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 ...
0
votes
1answer
100 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 ...
2
votes
5answers
695 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 ...
1
vote
2answers
300 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 ...
1
vote
1answer
125 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 ...
0
votes
1answer
372 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 ...
1
vote
1answer
246 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
vote
1answer
569 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 ...
0
votes
2answers
510 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 ...
2
votes
2answers
1k 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
vote
2answers
193 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 ...
1
vote
2answers
322 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 ...
0
votes
1answer
159 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 ...
1
vote
1answer
1k 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, ...
0
votes
2answers
461 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 ...
1
vote
0answers
227 views

Alter Fulltext Catalog Reorganize: Any issues to run this during daytime?

I have been going thru documents on Alter Fulltext Catalog Reorganize. But unlike Alter Index Reorganize, BOL(Books Online) documentation does not mention whether it's possible to run it without ...
0
votes
1answer
459 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 ...
1
vote
1answer
319 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 ...
1
vote
3answers
406 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', ), ...
1
vote
0answers
410 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 ...
3
votes
1answer
3k 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 ...
0
votes
1answer
1k 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?
0
votes
2answers
3k 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
vote
3answers
611 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
votes
1answer
2k 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.
2
votes
2answers
365 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?
0
votes
1answer
533 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 ...
2
votes
2answers
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 ...
2
votes
1answer
443 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
1answer
474 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 ...
1
vote
2answers
955 views

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 ...
3
votes
2answers
663 views

Local full text index for a directory tree, a quicker alternative for grep -R

I have a large directory tree of source files. I want to search around all these files. My first instinct is to use grep -R or ack, but either way they just sequentially read all the files. Is there ...
0
votes
1answer
435 views

IIS6 Indexing Service indexing asp.net codebehind (.aspx.cs) files

I've setup a few catalogs on an Windows Server 2003 IIS6 install, each tracking files within a website. In the Properties -> Generation Dialog for each catalog, 'Index files with unknown extensions' ...
8
votes
3answers
9k views

How to detect if full text search is installed in SQL Server

I need to find out if full text search is installed on SQL Server 2005. I don't have permission to log into the box and fire up Setup to check. However I can run SQL Server Management Studio and ...