Tag Info

Hot answers tagged

4

The full text engines in SQL 2000 and SQL 2008 are totally different. In SQL 2000 when you submit a full text query to the database, it searches the entire full text index and returns all matching rows to the full text query back, and then filters those down against the rows returned by your query using the normal filtering that you supplied as table ...


4

You can try Mysql or MongoDB full-text search capabilities. http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html http://www.mongodb.org/display/DOCS/Full+Text+Search+in+Mongo


3

Postgres has an outstanding out of the box support for full-text search. I do use Elasticsearch, I did migrate from sphinx, and yes, the learning curve is higher, but it worths as It has a really flexible way to query with JSON.


3

Unfortunately, you are just not going to get the same level of performance with the MySQL fulltext search as you will from the dedicated search solutions, but that begs the question--do you care? sphinxsearch will give you faster indexing, more advanced queries, incremental updates, and it will work out of the box with MySQL--but it is still a separate ...


3

Look at the list of services on the machine. If full text search is installed you'll see a service named SQL Server FullText Search ([instance]) where [instance] will be the name of the SQL instance that it is associated with.


3

Sounds like you want Beagle. Its main purpose is as a comprehensive desktop search, but you can tell it to just look at the source tree you want to index.


3

I believe Tracker is installed by default on Ubuntu. Do man trackerd and man tracker-search for more info. From the trackerd man page: By default, trackerd will index all files in a user’s home directory (with the exception of hidden files). This can be overridden by speci‐ fying one or more directories to be indexed instead in ...


3

The reason is performance based, yes. Lowering the default limit will increase the space required to store the indexes, and the increased index size takes longer to search. Impact will depend upon usage (the type of queries performed) and size of current data set. The default minimum is 4, you can lower it like so: [mysqld] ft_min_word_len=3 When you ...


2

HKLM\System\CurrentControlSet\Services can give you a lot of info that you might want. Tread with caution.


2

Apache Solr Solr is a standalone Enterprise Search Server. It presents a web service layer built atop the Lucene search library, extending it to provide application users with a ready-to-use search platform. Solr brings with it operational and administrative capabilities like web services, faceting, configurable schema, caching, replication, and ...


2

sc.exe at the command prompt OR the *-service set of PowerShell tools. At the command line, sc can do a bit of service frobbing and you can combine that with outputting to a text file or messing about with find. But really, you should be using PowerShell these days so Get-Service (as well as Start-Service, Restart Service, Set-Service, etc.) combined with ...


2

If you have the database-owner permission, that's all you need to do there. Full-text indexing is an option in the SQL Server installer. You may need to go back and add the feature. Other than that, these instructions should take care of you: http://sqlserverpedia.com/wiki/FTS_-_How_to_use_TSQL_to_Create_Full-Text_Indexes


2

Not with grep but you should be able to do it with awk or sed: sed -n '/key1/,/)/p' file.txt


2

sed -e 's/\(^.*<\)\(.*\)\(>.*$\)/\2/' yourfile.txt | sort |uniq its unix example, but you can get that utils for Windows command line sed http://gnuwin32.sourceforge.net/packages/sed.htm sort and uniq http://gnuwin32.sourceforge.net/packages/coreutils.htm


2

It sounds like an issue with the UNK table. The field was probably not created as a date/time field in the first place. Delete the FT index, do an offline compact, and re-build the FT index. See http://www-01.ibm.com/support/docview.wss?uid=swg21261002 for more info.


2

If that's an option, you can try Windows Search Server, a web site based on SharePoint. The express version is free: http://www.microsoft.com/enterprisesearch/searchserverexpress/en/us/default.aspx


2

I am not sure you can do anything the mysql full-text search is not really very good in my experience. Simple solutions. run less queries. mamy full text searches per page view is going to be expensive for the cpu. Redesign your database/application so that you update some kind of index table when content is inserted, instead of when a page is viewed. ...


2

A couple of strange things stand out here. Your system is 94.5% idle and yet MySQL is using 129% of your CPU. Something's very screwy there. MySQL is only using 3% of your available memory. I see a PHP process running there too so I guess this is a combined web and database box, but nonetheless I would expect you to give more RAM to MySQL, just make ...


1

The value of 84 for HA_FT_MAXCHARLEN is defined as a third of HA_FT_MAXBYTELEN (which is 254). This is defined in include/ft_global.h and changing it will mean recompiling MySQL - it is not a run-time variable. The reason it's a third is because in many character sets one character is not equal to one byte. If you were to change HA_FT_MAXBYTELEN and ...


1

You may also want to create a custom stopword list because there are 640 words that are excluded from FULLTEXT indexes. Some of those two letter words omitted are: on, of, it, is. Take a look at the full list. Perform the following Step 01) Create a stopwords.txt file echo "a" > C:\mysql_stopwords.txt echo "an" >> C:\mysql_stopwords.txt echo ...


1

Check out inotify. It will notify you about file system events instantaneously.


1

This is unanswerable. It may be minutes, or hours, or days. There's no way to know. The best you could do would be to read and follow this article in order to collect pre and post rebuild statistics that you can use in the future to "predict" how long a rebuild might take. ...


1

Personally, I'm a fan of PowerGrep from JGSoft (I'm a user, not affiliated). You can choose to group identical matches. You can download a trial, but in my opinion it's well worth the money.


1

Full text search is a feature of the Database Engine, and as such is not a main component of SQL Server 2008, but only a sub-feature; you don't need to apply the service pack to it, because it has already been applied to that Database Engine instance. If you were f.e. installing Analysis Services on a server where those weren't already installed, you would ...


1

I would start by stopping the server, and running mysqlcheck on that database (if you can't stop the server, then make a backup of the entire database, copy it to a different machine and run the checks there). The initial set of options would be to just check for errors. Once you have that, update your post with the details from that check and we'll take it ...


1

Altering a large table is going to take some time. You should have tested your changes before running them against production. I suspect it was a table that is written to. When you started the alteration, it became locked. When connections attempt to write to it, they wait for it to unlock. Eventually, all available connections filled waiting for the ...


1

When working in SQL Server 2008 and up, the full text searching is actually done by the SQL Server engine. The full text search service is still used, but only to do word breaking on the search query which is then passed right back to the database to do the actual searching. If you put the full text indexes on a different drive you can monitor the IO for ...


1

Indexing was not enabled. After enabling Windows Search and allowing the server to complete indexing this did not increase the speed of the search function. I also tried enabling the old Windows 2003 Index service and setup a catalog for the folder but it did not help (and actually slowed down the entire server the next day). Support from the developer is ...


1

You will need to find out exactly what mechanisms 'Invoice 2 Go' uses, and then you can start optimising your new server for it. This might require clever use of something like wireshark. Or figuring out where 2008 R2 treats the multiple opening of text files differently to 2003. First thing I would try, is turning - or making an exception with - the ...



Only top voted, non community-wiki answers of a minimum length are eligible