0
votes
3answers
660 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). ...
1
vote
1answer
518 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
313 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 ...
1
vote
2answers
265 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
120 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 ...
2
votes
2answers
933 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
0answers
130 views

Adding new word characters to UTF8 encoded mySQL table for a fulltext search

I have found in the docs where it describes how to add characters to the list of word characters used during fulltext searches. My table is encoded UTF8 and from what I can see, there isn't a ...
0
votes
2answers
427 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
2answers
882 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 ...