# Sphinx & Full-Text Search **URL:** https://forums.percona.com/c/polyglot-projects/sphinx-full-text-search/9.md [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) --- ## [About the Sphinx & Full-Text Search category](https://forums.percona.com/t/about-the-sphinx-full-text-search-category/14)
**Author:** [@system](https://forums.percona.com/u/system)\ **Replies:** 0
Sphinx & other full-text search topics. --- ## [how fulltext support chinese search](https://forums.percona.com/t/how-fulltext-support-chinese-search/2059)
**Author:** [@yejr](https://forums.percona.com/u/yejr)\ **Replies:** 17\ **Last updated:** [May 7, 2013, 3:50am UTC](https://forums.percona.com/t/how-fulltext-support-chinese-search/2059 "2013-05-07T03:50:11Z")
as title,thanks much. --- ## [Strange performance of mysql 5.5 on x86\_64](https://forums.percona.com/t/strange-performance-of-mysql-5-5-on-x86-64/2091)
**Author:** [@suside](https://forums.percona.com/u/suside)\ **Replies:** 2\ **Last updated:** [February 16, 2011, 8:41am UTC](https://forums.percona.com/t/strange-performance-of-mysql-5-5-on-x86-64/2091 "2011-02-16T08:41:04Z")
Hi I’ve noticed strange behavior of mysql 5.5 on x86\_64 (tested: binary&compiled 5.5.9, percona 5.5.8). My query is spending most of time in: #0 0x00000000005f5429 in cleanup\_items (item=0x363be88) at sql/sql\_parse.cc:… --- ## [sphinxse table: Lost connection to MySQL server during query](https://forums.percona.com/t/sphinxse-table-lost-connection-to-mysql-server-during-query/2090)
**Author:** [@msingla](https://forums.percona.com/u/msingla)\ **Replies:** 2\ **Last updated:** [January 31, 2011, 5:56pm UTC](https://forums.percona.com/t/sphinxse-table-lost-connection-to-mysql-server-during-query/2090 "2011-01-31T17:56:24Z")
I have successfully installed sphinx 1.10-beta. I have also installed sphinxse for same under MySQL Percona (5.1.53). I am able to create index and query against searchd daemon successfully using PHP. When I tried to … --- ## [FULL TEXT MEMORY USAGE](https://forums.percona.com/t/full-text-memory-usage/2088)
**Author:** [@xfactor5](https://forums.percona.com/u/xfactor5)\ **Replies:** 1\ **Last updated:** [January 1, 2011, 3:45pm UTC](https://forums.percona.com/t/full-text-memory-usage/2088 "2011-01-01T15:45:00Z")
Hi I searched everywhere to find sth about memory usage of full text tables but I couldnt find anything . I have a larg table with 277,000 rows all with medium lenght text data . I use full text index on the table . My… --- ## [Sphinx Search Engine](https://forums.percona.com/t/sphinx-search-engine/2089)
**Author:** [@Hemakumar.S](https://forums.percona.com/u/Hemakumar.S)\ **Replies:** 5\ **Last updated:** [November 24, 2010, 11:57pm UTC](https://forums.percona.com/t/sphinx-search-engine/2089 "2010-11-24T23:57:41Z")
Hai, I am trying to install wordpress sphinx search engine 0.4 version \[URL=“http://WordPress Sphinx Search Plugin – WordPress plugin | WordPress.org”\]http://wordpress.org/extend/plugins/wordpress-sphinx-plu… --- ## [how to make a fair comparison study](https://forums.percona.com/t/how-to-make-a-fair-comparison-study/2087)
**Author:** [@vick](https://forums.percona.com/u/vick)\ **Replies:** 0\ **Last updated:** [July 26, 2010, 9:13pm UTC](https://forums.percona.com/t/how-to-make-a-fair-comparison-study/2087 "2010-07-26T21:13:49Z")
Hello everyone and thanks for a great forum. I am a web developer with about 2 years of industry experience. I am currently in the last phase of my graduate studies and I have decided to write my thesis about MySQL and… --- ## [SphinxSE on MySQL 5.1.42 and Sphinx 0.9.9](https://forums.percona.com/t/sphinxse-on-mysql-5-1-42-and-sphinx-0-9-9/2083)
**Author:** [@krteq](https://forums.percona.com/u/krteq)\ **Replies:** 7\ **Last updated:** [June 21, 2010, 8:39am UTC](https://forums.percona.com/t/sphinxse-on-mysql-5-1-42-and-sphinx-0-9-9/2083 "2010-06-21T08:39:17Z")
Is there anyone, who has successfully compilled SphinxSE using MySQL 5.1.42 and Sphinx 0.9.9 sources? Sphinx forum is completely quiet about this… \[URL\]sphinx engine 0.9.9 compilation problem with xtradb 5.1.42 | Sphin… --- ## [Sphinx-FTS index structure details?](https://forums.percona.com/t/sphinx-fts-index-structure-details/2086)
**Author:** [@nageshvh](https://forums.percona.com/u/nageshvh)\ **Replies:** 2\ **Last updated:** [May 18, 2010, 2:49pm UTC](https://forums.percona.com/t/sphinx-fts-index-structure-details/2086 "2010-05-18T14:49:04Z")
Hi, I have been searching for quite a while about sphinx full text indexing structure and haven’t got specifically helpful results. I intend to learn about sphinx indexing structure and answer these questions How doe… --- ## [What will be the best way to load tables in memory to speed up access.](https://forums.percona.com/t/what-will-be-the-best-way-to-load-tables-in-memory-to-speed-up-access/2085)
**Author:** [@ucables](https://forums.percona.com/u/ucables)\ **Replies:** 7\ **Last updated:** [May 12, 2010, 6:45am UTC](https://forums.percona.com/t/what-will-be-the-best-way-to-load-tables-in-memory-to-speed-up-access/2085 "2010-05-12T06:45:52Z")
i have much traffic at my site. Queries are always different, so query cache not works. my products table is not modified never, so i think the best way should be to use a memory engine for this table, but it doesnt su… --- ## [Mysql FULLTEXT optimization](https://forums.percona.com/t/mysql-fulltext-optimization/2084)
**Author:** [@ucables](https://forums.percona.com/u/ucables)\ **Replies:** 2\ **Last updated:** [May 10, 2010, 11:14am UTC](https://forums.percona.com/t/mysql-fulltext-optimization/2084 "2010-05-10T11:14:44Z")
i have a table of products with 200.000 products with full text search indexes size of table is: 405 Mb, size of indexes is: 526 Mb I would like to optimize search time, because my server load is very high. my product… --- ## [AND as the default modifier for boolean search](https://forums.percona.com/t/and-as-the-default-modifier-for-boolean-search/2068)
**Author:** [@Spuerhund](https://forums.percona.com/u/Spuerhund)\ **Replies:** 1\ **Last updated:** [March 29, 2010, 6:39am UTC](https://forums.percona.com/t/and-as-the-default-modifier-for-boolean-search/2068 "2010-03-29T06:39:13Z")
I would like to offer my users the same behaviour that they are already used to. Let’s take for example Google. Google has “AND” as the default operator, which means that you get less and less results with every word tha… --- ## [MySQL Fulltext Query problem on MySQL 5.1](https://forums.percona.com/t/mysql-fulltext-query-problem-on-mysql-5-1/2082)
**Author:** [@hi\_irf](https://forums.percona.com/u/hi_irf)\ **Replies:** 2\ **Last updated:** [December 29, 2009, 10:51pm UTC](https://forums.percona.com/t/mysql-fulltext-query-problem-on-mysql-5-1/2082 "2009-12-29T22:51:57Z")
Hi, I upraded my database server from 4.1 to 5.1.32. But somehow following query doesn’t shows any results in 5.1 it just running look likes query hung. mysql 5.1.32\> SELECT colname FROM table1 WHERE (related=1 or rel… --- ## [Creating a custom stoplist from actual data](https://forums.percona.com/t/creating-a-custom-stoplist-from-actual-data/2076)
**Author:** [@myraz](https://forums.percona.com/u/myraz)\ **Replies:** 2\ **Last updated:** [December 25, 2009, 9:54am UTC](https://forums.percona.com/t/creating-a-custom-stoplist-from-actual-data/2076 "2009-12-25T09:54:46Z")
I have some huge fulltext indexes created using ft\_min\_wordlen=2 and no stoplist. The data is not english language so the default stoplist cannot be used. I have this idea if you could ‘look’ at the current index (using… --- ## [Sphinx with Arabic](https://forums.percona.com/t/sphinx-with-arabic/2077)
**Author:** [@ronin1770](https://forums.percona.com/u/ronin1770)\ **Replies:** 1\ **Last updated:** [December 25, 2009, 6:58am UTC](https://forums.percona.com/t/sphinx-with-arabic/2077 "2009-12-25T06:58:17Z")
Hi Guyz, Just wondering if it is possible to use Arabic content with Sphinx. I am creating a small search engine in Arabic. Ronin1770 --- ## [Slow Full-Text Search when table grows constantly](https://forums.percona.com/t/slow-full-text-search-when-table-grows-constantly/2073)
**Author:** [@cod\_ferrow](https://forums.percona.com/u/cod_ferrow)\ **Replies:** 1\ **Last updated:** [December 25, 2009, 6:57am UTC](https://forums.percona.com/t/slow-full-text-search-when-table-grows-constantly/2073 "2009-12-25T06:57:04Z")
Hello, I have a small issue with a web-search engine I’m working on. The main table is constantly growing (1 insert per second, currently 150 000 records) and it has full-text indexes on 2 fields that contain over 20 00… --- ## [How to write a UDF for MySQL fulltext tokenization?](https://forums.percona.com/t/how-to-write-a-udf-for-mysql-fulltext-tokenization/2071)
**Author:** [@howachen](https://forums.percona.com/u/howachen)\ **Replies:** 1\ **Last updated:** [December 25, 2009, 6:56am UTC](https://forums.percona.com/t/how-to-write-a-udf-for-mysql-fulltext-tokenization/2071 "2009-12-25T06:56:21Z")
I want to write a UDF for tokenize Chinese so that MySQL fulltext can cover that, any docs/article I can get started with? Thanks. D --- ## [Getting 1000 documents by id from MySQL / Sphinx](https://forums.percona.com/t/getting-1000-documents-by-id-from-mysql-sphinx/2081)
**Author:** [@nerolabs](https://forums.percona.com/u/nerolabs)\ **Replies:** 5\ **Last updated:** [November 4, 2009, 1:19pm UTC](https://forums.percona.com/t/getting-1000-documents-by-id-from-mysql-sphinx/2081 "2009-11-04T13:19:54Z")
Dear Percona Community: I have a successful sphinx installation that is returning 1000 document IDs on common queries, and it performs the search in less that 0.2 seconds in nearly every case. However, when I take thes… --- ## [Query with match against another table field...](https://forums.percona.com/t/query-with-match-against-another-table-field/2080)
**Author:** [@gnagno](https://forums.percona.com/u/gnagno)\ **Replies:** 0\ **Last updated:** [September 28, 2009, 6:33am UTC](https://forums.percona.com/t/query-with-match-against-another-table-field/2080 "2009-09-28T06:33:05Z")
Hello all, I have this situation: Table A strings id int string varchar(255) Table B cities id int name varchar(255) I need to compare all the city names with the strings in Table A to find in which strings the… --- ## [Using Group by in Full text search](https://forums.percona.com/t/using-group-by-in-full-text-search/2079)
**Author:** [@charanv](https://forums.percona.com/u/charanv)\ **Replies:** 2\ **Last updated:** [March 16, 2009, 9:49am UTC](https://forums.percona.com/t/using-group-by-in-full-text-search/2079 "2009-03-16T09:49:54Z")
Hi All I am writing a query that would pull out results from a database using a fulltext search. The query goes like this “select \* from tbl\_products WHERE MATCH(productname, productkeywords, product\_description, p… --- ## [Plurals in natural language fulltext search?](https://forums.percona.com/t/plurals-in-natural-language-fulltext-search/2078)
**Author:** [@davidjay202](https://forums.percona.com/u/davidjay202)\ **Replies:** 1\ **Last updated:** [December 11, 2008, 10:27am UTC](https://forums.percona.com/t/plurals-in-natural-language-fulltext-search/2078 "2008-12-11T10:27:54Z")
Hi, I’m trying to find a way to resolve the plural problem without the need to add the plural variation as a keyword to the data record. The boolean fulltext search has the option of a wild card ie book\* which will fin… --- ## [Search Not Using Index Across Join](https://forums.percona.com/t/search-not-using-index-across-join/2075)
**Author:** [@threadhead](https://forums.percona.com/u/threadhead)\ **Replies:** 2\ **Last updated:** [October 1, 2008, 7:25pm UTC](https://forums.percona.com/t/search-not-using-index-across-join/2075 "2008-10-01T19:25:33Z")
When I perform a full text query across two tables, it doesn’t appear that the fulltext indices are being used. Or maybe it is, and I just don’t see it. Here are my two tables: CREATE TABLE events ( id int(11) NOT NULL … --- ## [Sphinx - only for string based search?](https://forums.percona.com/t/sphinx-only-for-string-based-search/2074)
**Author:** [@razdaman](https://forums.percona.com/u/razdaman)\ **Replies:** 2\ **Last updated:** [May 6, 2008, 2:05am UTC](https://forums.percona.com/t/sphinx-only-for-string-based-search/2074 "2008-05-06T02:05:08Z")
“Generally, it’s a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications.” (From sphinxsearch.com) Does this mean that the sphinx engine only shoul… --- ## [Japanese characters full text search](https://forums.percona.com/t/japanese-characters-full-text-search/2072)
**Author:** [@arthurica](https://forums.percona.com/u/arthurica)\ **Replies:** 0\ **Last updated:** [January 31, 2008, 2:23am UTC](https://forums.percona.com/t/japanese-characters-full-text-search/2072 "2008-01-31T02:23:11Z")
I am having some problems searching using the MATCH function for japanese words… Here is the situation… As you might know japanese words are not separate with spaces… Here are 2 words (a composite one and a simple one) … --- ## [How to search by using normal index and full text together](https://forums.percona.com/t/how-to-search-by-using-normal-index-and-full-text-together/2070)
**Author:** [@bigrio](https://forums.percona.com/u/bigrio)\ **Replies:** 1\ **Last updated:** [January 2, 2008, 2:38am UTC](https://forums.percona.com/t/how-to-search-by-using-normal-index-and-full-text-together/2070 "2008-01-02T02:38:22Z")
Hello~ I am not so experienced on fulltext search and fulltext search engine. If my understanding is not so good, please forgive me. Our site is social networking site and I am rebuilding all the database architecture… --- ## [DB Design for search](https://forums.percona.com/t/db-design-for-search/2065)
**Author:** [@shivaball](https://forums.percona.com/u/shivaball)\ **Replies:** 4\ **Last updated:** [December 4, 2007, 4:41pm UTC](https://forums.percona.com/t/db-design-for-search/2065 "2007-12-04T16:41:22Z")
Hi Forum, my name is Thomas and i’m new here. I have a question about design for search engine on a platform where the given politic is to use mysiam engine. No i designed a search engine for the given data and i don’… --- ## [Slow COUNT query that uses a fulltext index](https://forums.percona.com/t/slow-count-query-that-uses-a-fulltext-index/2069)
**Author:** [@hammet](https://forums.percona.com/u/hammet)\ **Replies:** 1\ **Last updated:** [December 3, 2007, 2:45am UTC](https://forums.percona.com/t/slow-count-query-that-uses-a-fulltext-index/2069 "2007-12-03T02:45:03Z")
Hi, I have a slow count(\*) query that uses a fulltext index and i can’t find out why execution time is so awful. The query as it stands takes about ~2-5 sec to execute, depends of found rows quantity. Here’s the query… --- ## [Logic behind full text search index](https://forums.percona.com/t/logic-behind-full-text-search-index/2067)
**Author:** [@srirams](https://forums.percona.com/u/srirams)\ **Replies:** 1\ **Last updated:** [September 24, 2007, 5:21am UTC](https://forums.percona.com/t/logic-behind-full-text-search-index/2067 "2007-09-24T05:21:17Z")
Hi, I am trying to figure out the way fulltext search index works. I have a table which have 5 columns. 3 columns have been added into full text search index. Here is the same data of 2 rows and the data belonging to… --- ## [fulltext search with additional condition in the where clause](https://forums.percona.com/t/fulltext-search-with-additional-condition-in-the-where-clause/2066)
**Author:** [@dimitar](https://forums.percona.com/u/dimitar)\ **Replies:** 1\ **Last updated:** [September 3, 2007, 7:02am UTC](https://forums.percona.com/t/fulltext-search-with-additional-condition-in-the-where-clause/2066 "2007-09-03T07:02:11Z")
Hello, I have a table “products” with around 1,000,000 records. The table structure is: CREATE TABLE products ( product\_id int(15) unsigned NOT NULL default ‘0’, store\_id int(7) unsigned NOT NULL default ‘0’, title… --- ## [Fulltext search with order by static field](https://forums.percona.com/t/fulltext-search-with-order-by-static-field/2061)
**Author:** [@al.james](https://forums.percona.com/u/al.james)\ **Replies:** 3\ **Last updated:** [August 19, 2007, 10:40pm UTC](https://forums.percona.com/t/fulltext-search-with-order-by-static-field/2061 "2007-08-19T22:40:25Z")
Hi there… I need to optimise: SELECT \* FROM table WHERE MATCH(text\_field) AGAINST (‘text’) ORDER BY score DESC; where score is a pre-computed int field. At the moment, despite text\_field and score both having indices… [Next page](https://forums.percona.com/c/polyglot-projects/sphinx-full-text-search/9.md?page=1)