IntegrateSphinx - Revision history

Phanousk: /* Integrating the Sphinx full-text search engine in RT */

2017-09-21T10:05:59Z

Integrating the Sphinx full-text search engine in RT

← Older revision		Revision as of 06:05, 21 September 2017
Line 3:		Line 3:
	= Integrating the Sphinx full-text search engine in RT =		= Integrating the Sphinx full-text search engine in RT =
	* [http://sphinxsearch.com/ homepage Sphinx]		* [http://sphinxsearch.com/ homepage Sphinx]
	* [https://blog.christosoft.de/2016/07/rt4-request-tracker4-fulltext-search-sphinx-debian-jessie/ Recent guide for running SphinxSearch ~~with MariaDB~~] – MariaDB is OpenSource fork of MySQL and is binary compatible with that. It's completely safe to migrate (even when using non-english characters).		* [https://blog.christosoft.de/2016/07/rt4-request-tracker4-fulltext-search-sphinx-debian-jessie/ Recent guide for running RT on MariaDB with SphinxSearch] – MariaDB is OpenSource fork of MySQL and is binary compatible with that. It's completely safe to migrate (even when using non-english characters).

	----		----

Phanousk: added recent guide for installation of SphinxSearch

2017-09-21T10:05:13Z

added recent guide for installation of SphinxSearch

← Older revision		Revision as of 06:05, 21 September 2017
Line 2:		Line 2:

	= Integrating the Sphinx full-text search engine in RT =		= Integrating the Sphinx full-text search engine in RT =
			* [http://sphinxsearch.com/ homepage Sphinx]
	[http://sphinxsearch.com/ homepage Sphinx]		* [https://blog.christosoft.de/2016/07/rt4-request-tracker4-fulltext-search-sphinx-debian-jessie/ Recent guide for running SphinxSearch with MariaDB] – MariaDB is OpenSource fork of MySQL and is binary compatible with that. It's completely safe to migrate (even when using non-english characters).

	----		----

Cris70: /* The search daemon */

2016-06-21T08:20:46Z

The search daemon

← Older revision		Revision as of 04:20, 21 June 2016
Line 209:		Line 209:
	We do this with the command		We do this with the command

	/usr/local/bin/searchd --config /usr/local/etc/sphinx.conf		<pre>/usr/local/bin/searchd --config /usr/local/etc/sphinx.conf</pre>

	In our experience <code>searchd</code> is not very stable (probably due to the beta release): it stops responding after a couple days of uptime, so we restart it daily.		In our experience <code>searchd</code> is not very stable (probably due to the beta release): it stops responding after a couple days of uptime, so we restart it daily.
Line 216:		Line 216:

	----		----


	== Second: using the API to query Sphinx ==		== Second: using the API to query Sphinx ==

Cris70: /* Building the indexes */

2016-06-21T08:20:17Z

Building the indexes

← Older revision		Revision as of 04:20, 21 June 2016
Line 185:		Line 185:
	You can initialize the indexes with the command:		You can initialize the indexes with the command:

	/usr/local/bin/indexer --all		<pre>/usr/local/bin/indexer --all</pre>


Line 194:		Line 194:
	We refresh the <code>fulltext1</code> index once a day at 7 a.m., with this command:		We refresh the <code>fulltext1</code> index once a day at 7 a.m., with this command:

	/usr/local/bin/indexer --rotate fulltext1		<pre>/usr/local/bin/indexer --rotate fulltext1</pre>


Line 201:		Line 201:
	We refresh the <code>fulltextdelta</code> index every 5 minutes with this command:		We refresh the <code>fulltextdelta</code> index every 5 minutes with this command:

	/usr/local/bin/indexer --rotate fulltextdelta		<pre>/usr/local/bin/indexer --rotate fulltextdelta</pre>



	==== The search daemon ====		==== The search daemon ====

Cris70: Corrected formatting for the new wiki

2016-06-20T07:41:28Z

Corrected formatting for the new wiki

Show changes

Cris70 at 06:54, 20 June 2016

2016-06-20T06:54:35Z

← Older revision		Revision as of 02:54, 20 June 2016
Line 1:		Line 1:
	Contributed by [~~http~~:~~//wiki.bestpractical.com/view/Cris~~ Cris]		Contributed by [[User:Cris70\|Cris]]

	= Integrating the Sphinx full-text search engine in RT =		= Integrating the Sphinx full-text search engine in RT =

Admin: 13 revisions imported

2016-04-06T20:11:29Z

13 revisions imported

← Older revision		Revision as of 16:11, 6 April 2016
(No difference)

Cris70: /* Intro */

2013-02-05T08:56:58Z

Intro

← Older revision		Revision as of 04:56, 5 February 2013
Line 39:		Line 39:
	I will describe here briefly the meaning of these two options; if you want more infos please refer to the Sphinx homepage.		I will describe here briefly the meaning of these two options; if you want more infos please refer to the Sphinx homepage.

	Real-time indexes (on the Sphinx site they call them RT-indexes... quite confusing, uh?) are a clever way to have your indexes always updated, up to the millisecond. They are however still in beta (as of 1.10-beta) and they are more complex to set up and update. We wanted a quick solution, so we ~~choose~~ the traditional way.		Real-time indexes (on the Sphinx site they call them RT-indexes... quite confusing, uh?) are a clever way to have your indexes always updated, up to the millisecond. They are however still in beta (as of 1.10-beta) and they are more complex to set up and update. We wanted a quick solution, so we chose the traditional way.

	The traditional way consists of having to indexes: one '''big''' index comprising all tickets up to a certain date (or to a certain ID), and a small '''delta''' index for the rest of the tickets. You can use only one big index, but it will take a few minutes to build it so you cannot refresh it too frequently. If you use the full+delta approach you can build the big index e.g. once a day and the delta index once every few minutes.		The traditional way consists of having two indexes: one '''big''' index comprising all tickets up to a certain date (or to a certain ID), and a small '''delta''' index for the rest of the tickets. You can use only one big index, but it will take a few minutes to build it so you cannot refresh it too frequently. If you use the full+delta approach you can build the big index e.g. once a day and the delta index once every few minutes.

	Presently we have about 15 thousand tickets in our RT db; we build the full index every morning, indexing everything up to the first day of the current month: it takes about 8 minutes. The delta index (from start of month to now) is built every 5 minutes and it takes about a couple seconds.		Presently we have about 15 thousand tickets in our RT db; we build the full index every morning, indexing everything up to the first day of the current month: it takes about 8 minutes. The delta index (from start of month to now) is built every 5 minutes and it takes about a couple seconds.

212.24.153.186: /* phinx setup */

2012-06-07T11:27:23Z

phinx setup

Show changes

212.24.153.186: /* Sphinx setup */

2012-06-07T11:27:09Z

Sphinx setup

Show changes