It looks perfect.
Thanks
Google for myisam_ftdump, HTH Cor
- Original Message - From: Sebastien Moretti
sebastien.more...@unil.ch
To: mysql@lists.mysql.com
Sent: Thursday, April 23, 2009 5:24 PM
Subject: How to show highly frequent words in fulltext index ?
Hi,
Is there a command
Hi,
Is there a command to see which words are highly frequent in a fulltext
index ?
Thanks
--
Sébastien Moretti
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Yes,
you can use myisam_ftdump
Bye
On Thu, 23 Apr 2009 17:24:09 +0200, Sebastien Moretti
sebastien.more...@unil.ch wrote:
Hi,
Is there a command to see which words are highly frequent in a fulltext
index ?
Thanks
--
Sébastien Moretti
--
MySQL General Mailing List
For list
Can one make a composite index with FULLTEXT for one column and standard
indexing on another?
For instance we have a table
CREATE TABLE OurData
(
TheText TEXT,
TheLanguageID INTEGER
);
We have a FULLTEXT index on TheText, but want to be able to do searches
on TheText
Hi all:
I am trying to build a FULLTEXT index with several particularities. It
must ignore some special characters inside index words. For example:
If I have the text:
I'll go to the ci[ne]ma.
I want the FULLTEXT include the word cinema, not ci[ne]ma nor ci or ne or
ma. So, I want the index
Hi
Is sphinxsearch avialable only on for windows
regards
anandkl
On 6/13/08, Rory McKinley [EMAIL PROTECTED] wrote:
mos wrote:
snip
Why not switch to Sphinx full text search for MySQL? It is faster and can
handle more data than MySQL's built in fulltext search.
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 10:48 AM
To: [EMAIL PROTECTED]
Cc: mos; mysql@lists.mysql.com
Subject: Re: Fulltext index -first query slow, subsequent queries fast
Hi
Is sphinxsearch avialable only on for windows
Hi List
I have a table with a fulltext index across five fields, with about 2.2
million records and a data size of about 5.6 GB (index another 3.5 GB).
When I test a query that uses fulltext matching, the first run takes
about 15-16 seconds to complete. The second run takes about 0.1 sec
-Original Message-
From: Rory McKinley [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 3:20 PM
To: mysql
Subject: Fulltext index -first query slow, subsequent queries fast
Hi List
I have a table with a fulltext index across five fields, with about 2.2
million records and a data
system. The system might keep the
most recently used stuff, the most frequently used stuff, even the stuff it
thinks you will need based upon the pattern of use.
Regards,
snip
Hi Jerry
Thanks for the explanation.
So, in short, I am most likely hitting a wall with the fulltext index,
and I am just
From: Rory McKinley [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 4:57 PM
To: Jerry Schwartz; mysql
Subject: Re: Fulltext index -first query slow, subsequent queries fast
Jerry Schwartz wrote:
File system, or disk caching, uses some kind of algorithm to hold
chunks of
files in system
At 02:20 PM 6/12/2008, you wrote:
Hi List
I have a table with a fulltext index across five fields, with about 2.2
million records and a data size of about 5.6 GB (index another 3.5 GB).
When I test a query that uses fulltext matching, the first run takes about
15-16 seconds to complete
mos wrote:
snip
Why not switch to Sphinx full text search for MySQL? It is faster and
can handle more data than MySQL's built in fulltext search.
http://www.sphinxsearch.com/
Mike
snip
I have read about sphinx and the good performance boost it provides -
unfortunately there is a lot of
I'm wanting to add a new field to my table that I will both be grouping by,
searching with full text hits and plain likes..
I know I'll need a FULL TEXT index, but will that full text index also index
like a normal index will? or should I also add an index too..
thanks.
Justin wrote:
I'm wanting to add a new field to my table that I will both be
grouping by, searching with full text hits and plain likes..
I know I'll need a FULL TEXT index, but will that full text index
also index like a normal index will? or should I also add an index
too..
You'll need to
(nom_en) against ('Huile');[/quote]
When I put two arguments:
[quote]SELECT * FROM item WHERE MATCH (nom,nom_en) against ('Huile');
[/quote]
It says: Can't find FULLTEXT index matching the column list, but both nom
and nom_en are FULLTEXT indexed and the table item is MyISAM.
You need another
('Huile');[/quote]
When I put two arguments:
[quote]SELECT * FROM item WHERE MATCH (nom,nom_en) against ('Huile');
[/quote]
It says: Can't find FULLTEXT index matching the column list, but both nom
and nom_en are FULLTEXT indexed and the table item is MyISAM.
Anyone can help? thank you
--
View
On 5/11/2006 9:17 AM Fan, Wellington wrote:
Damn, I really didn't mean to use that subject line; Sorry all!
Nor should you reply to a message when starting a new thread. It screws
up the threading whether or not you change the subject. Please start
all new threads with a new message.
.
But, when I tried this:
SELECT * FROM products
WHERE match (prod_name, prod_description) against ('+red +shirt');
I got this error message:
#1191 - Can't find FULLTEXT index matching the column list
What am I doing wrong?
You put 2 FULLTEXT indexes on different columns, and you're trying
+shirt');
I'll get some results.
But, when I tried this:
SELECT * FROM products
WHERE match (prod_name, prod_description) against ('+red +shirt');
I got this error message:
#1191 - Can't find FULLTEXT index matching the column list
What am I doing wrong?
You put 2 FULLTEXT indexes
WHERE match (prod_name, prod_description) against ('+red +shirt');
I got this error message:
#1191 - Can't find FULLTEXT index matching the column list
What am I doing wrong?
Thanks for any help.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
, prod_description) against ('+red +shirt');
I got this error message:
#1191 - Can't find FULLTEXT index matching the column list
What am I doing wrong?
You need a single FULLTEXT index that contains both of the columns
you're searching on.
From http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html
products
WHERE match (prod_name) against ('+red +shirt');
I'll get some results.
But, when I tried this:
SELECT * FROM products
WHERE match (prod_name, prod_description) against ('+red +shirt');
I got this error message:
#1191 - Can't find FULLTEXT index matching the column list
Hello all,
I just inherited an application that has 2 tables under consideration, events
and attribute_master. They are linked on (events.eventID =
attribute_master.id AND attribute_master.tableis = 'events'). In other words,
attribute_master.id is kinda like a foreign key to events.eventID,
Damn, I really didn't mean to use that subject line; Sorry all!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dude! You just confused me with YOUR QUESTION under MY SUBJECT LINE
:) :) :)
You have to change a Subject and send it again. Or we will not know to
whom is sent.
:)
-afan
Hello all,
I just inherited an application that has 2 tables under consideration,
events and attribute_master. They
this error message:
#1191 - Can't find FULLTEXT index matching the column list
What am I doing wrong?
You need a single FULLTEXT index that contains both of the columns
you're searching on.
From http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html :
For natural-language full-text searches
products
WHERE match (prod_name, prod_description) against ('+red +shirt');
I got this error message:
#1191 - Can't find FULLTEXT index matching the column list
What am I doing wrong?
You need a single FULLTEXT index that contains both of the columns
you're searching on.
From http
, prod_description) against ('+red +shirt');
I got this error message:
#1191 - Can't find FULLTEXT index matching the column list
What am I doing wrong?
Thanks for any help.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Dear develepment team,
i?d like to access the entries of an fulltext index directly. Is there
another, more conveniant possibility than exporting the entries with
myisam_ftdump /var/db/mysql/cms/faq_data 2 -c and importing the entries in
an extra table for querying?
This feature would
Hi, I would like to know if the support for fulltext index on ucs2-columns will
be added and if so when.
BR /Kenneth Lindh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a table which includes the following columns in addition to
lots of other ones
name - populated with just one name
city - populated with just one city
keywords - lots of keywords
I'm definitely going to use a FULLTEXT on the `keywords` column
For `name` and `city` ...I will allow users
I did a little test by configure the `name` and `city` with FULLTEXT
INDEX and a regular INDEX.
mysql describe testing_text_performance;
+---+--+--+-+---++
| Field | Type | Null | Key | Default |
Extra
Responses interspersed
James [EMAIL PROTECTED] wrote on 06/22/2005 04:48:59 PM:
I did a little test by configure the `name` and `city` with FULLTEXT
INDEX and a regular INDEX.
mysql describe testing_text_performance
for a foreign key relationship .
Anyway, I want to create a fulltext index on the table, but I cannot because it
is not supported by InnoDB, but by MyISAM (according to the docs).
As it stands I have 1000+ records in the table, and do not know what to do. Can
I alter the table to be MyISAM? And what
Hi,
I've implemented my site search using MySQL db fulltext index. I
understand that fulltext index currently doesn't support stemming of
words.
However I want to implement my search such that a query containing
words in singular tense matches records of words in plural tense and
vice versa
All,
- Original Message -
From: mos [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, January 30, 2005 6:29 AM
Subject: Re: FULLTEXT index on InnoDB tables (looking for a workaround)
At 02:32 PM 1/28/2005, you wrote:
And, of course, another option is to contact Heikki
At 02:32 PM 1/28/2005, you wrote:
And, of course, another option is to contact Heikki and coax him into
hiring somebody to add FULLTEXT to InnoDB tables.
And bring lots of cash with you. :-) I've pestered Heikki a couple of years
ago and he's willing to do it only if there is someone willing to
Dear friends,
I would need to index FULLTEXT two columns in a InnoDB table. How do you solve
the problem?
--
symbulos partners
-.-
symbulos - ethical services for your organisation
http://www.symbulos.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hello,
I would need to index FULLTEXT two columns in a InnoDB table. How do you
solve
the problem?
As you have noticed - you cannot.
So, all you can do is creating a MyISAM table and copying
the column contents.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase,
On Friday 28 Jan 2005 15:41, you wrote:
As you have noticed - you cannot.
So, all you can do is creating a MyISAM table and copying
the column contents.
Are you suggesting to have a full copy of the table in MyISAM format?
Is there any other workaround? The reason because we are using InnoDB
symbulos partners [EMAIL PROTECTED] wrote on 01/28/2005 11:14:00 AM:
On Friday 28 Jan 2005 15:41, you wrote:
As you have noticed - you cannot.
So, all you can do is creating a MyISAM table and copying
the column contents.
Are you suggesting to have a full copy of the table in MyISAM
As you have noticed - you cannot.
So, all you can do is creating a MyISAM table and copying
the column contents.
Are you suggesting to have a full copy of the table in MyISAM format?
No, only the BLOB/TEXT columns need to be moved to MyISAM.
Is there any other workaround?
Thanks for the extremely useful answer.
Some comments, questions here below.
On Friday 28 Jan 2005 16:38, you wrote:
No, only the BLOB/TEXT columns need to be moved to MyISAM.
Yes, I thought of doing so. The drawback is that you de-normalise the
database. Is that correct?
There are 2
Thanks for the extremely useful answer.
Some comments, questions here below.
On Friday 28 Jan 2005 16:38, you wrote:
No, only the BLOB/TEXT columns need to be moved to MyISAM.
Yes, I thought of doing so. The drawback is that you de-normalise the
database. Is that correct?
There are 2
symbulos partners wrote:
Is there any other workaround? The reason because we are using InnoDB is
because there s full support
- for foreign keys,
- for joint queries
- for rollback on commit
Does anybody know any other way of indexing the table in a way, which would
allow full text search?
symbulos partners wrote:
Thanks for the extremely useful answer.
Some comments, questions here below.
On Friday 28 Jan 2005 16:38, you wrote:
No, only the BLOB/TEXT columns need to be moved to MyISAM.
Yes, I thought of doing so. The drawback is that you de-normalise the
database. Is that
Hi again.
PROCESS LIST is:
Creating tmp file
Repair by sorting
The problem occurs while repair by sorting.
myisam parameters have been increased accordingly:
myisam max extra sort file size = 15000M
myisam max sort file size = 15000M
There must be a bug somewhere? What do you suggest?
Vincent
Hi!
Hi!
On Jul 06, Vincent Bouret wrote:
Hi,
I got the following values:
key_buffer_size = 256M
myisam max extra sort file size = 8000M
myisam max sort file size = 8000M
myisam sort buffer size = 128M
But that big table (MYD = 2397 MB), rows = 5 355 866 still won't index
in full text.
, the fulltext index creation on very huge sets of data doesn't
seem to work.
I have switched from 4.0.14 to 4.0.20 and rebuilt the database from
scratch. I'm adding a lot of data on different tables (4 TEXT
fields/table). At the end, I issue a ALTER TABLE 'tablename' ADD
FULLTEXT ('field1'), ADD FULLTEXT
Mysqlians,
I just discovered that a server has ft_min_word_len=4 when I want
ft_min_word_len=3 . Do I have to rebuild all the fulltext indicies so
that searches on three-letter words will work correctly?
Trevor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
At 12:30 -0700 5/18/04, Trevor Price wrote:
Mysqlians,
I just discovered that a server has ft_min_word_len=4 when I
want ft_min_word_len=3 . Do I have to rebuild all the fulltext
indicies so that searches on three-letter words will work correctly?
Yes.
Question:
Did you find some place in
.
Matt
- Original Message -
From: [EMAIL PROTECTED]
Sent: Wednesday, April 28, 2004 12:01 AM
Subject: fulltext index -- word needs not found
Description:
We have three different unrelated tables, each with one field that
has a fulltext index. In each table, in the field with the fulltext
Description:
We have three different unrelated tables, each with one field that
has a fulltext index. In each table, in the field with the fulltext
index, there are records with the word needs in them, and in each case no
records are found when doing this type of query (using a fulltext
work fine, but INSERT hangs.
Thanks,
Don
Jaroslav Kocourek wrote:
FWIW, I'm still having this problem.
I've completely dropped the table and re-built it from the ground up.
It's a bizarre problem... The table is totally simple. A primary key,
and then three varchar fields. The FULLTEXT
.
It's a bizarre problem... The table is totally simple. A primary
key, and then three varchar fields. The FULLTEXT index spans the 3
varchar fields. There are only 6500+ rows, so it's pretty tiny.
A mysqldump of the table is only 442K.
Has no-one else seen anything like this? I can't
FWIW, I'm still having this problem.
I've completely dropped the table and re-built it from the ground up.
It's a bizarre problem... The table is totally simple. A primary key,
and then three varchar fields. The FULLTEXT index spans the 3 varchar
fields. There are only 6500+ rows, so it's
I am trying to add a second fulltext index to an already existing table
(named articles).
The first index is for field(column name) text of type longtext
I want to add a second index that will be for this field and
field(column name) title of type varchar
I used this query: alter table
I find doing this helps to reinitialize the indexes
ALTER TABLE shotlist TYPE=MyISAM;
REPAIR TABLE shotlist QUICK;
I am trying to add a second fulltext index to an already existing table
(named articles).
The first index is for field(column name) text of type longtext
I want to add
: sascha mantscheff
Sent: Friday, April 09, 2004 4:21 PM
Subject: Fulltext index is not being built with large database
I'm trying to build a fulltext index on a table with about 4 million
entries with 2 varchar and one text field.
The indexing starts and runs for about 1/2 to 1 hour
log for anything
related?
Matt
- Original Message -
From: sascha mantscheff
Sent: Friday, April 09, 2004 4:21 PM
Subject: Fulltext index is not being built with large database
I'm trying to build a fulltext index on a table with about 4 million
entries with 2 varchar and one text field
I'm trying to build a fulltext index on a table with about 4 million
entries with 2 varchar and one text field.
The indexing starts and runs for about 1/2 to 1 hour, then the process
stops without any error message. And leaves me with no index. I checked
for the size in tmp and redirected
Hi there,
I've got a bizarre problem I can't seem to solve. I have a small MyISAM
table (6533 rows) with a small FULLTEXT index (3 columns per row, an
average of 1 word per column). When I do an INSERT on the table, many
times the thread gets stuck perpetually in Query | update. Future
Is there any way to iterate thru the keys in a fulltext index? This issue
does not come up for other indexes since ORDER BY can achieve this:
For example if table t is indexed on part_id
SELECT DISTINCT part_id FROM t ORDER by part_id;
will return all keys in index order
Is there a way
Hi!
On Mar 05, Todd Burke wrote:
Is there any way to iterate thru the keys in a fulltext index? This issue
does not come up for other indexes since ORDER BY can achieve this:
For example if table t is indexed on part_id
SELECT DISTINCT part_id FROM t ORDER by part_id;
will return
Hi Sergei!
Great news. Thanks very much! :-)
Matt
- Original Message -
From: Sergei Golubchik
Sent: Tuesday, February 03, 2004 1:54 PM
Subject: Re: query the data of a fulltext index directly from index?
Hi!
On Feb 02, Matt W wrote:
Sergei,
Any chance of getting a ft_dump
Sergei,
Any chance of getting a ft_dump Windows binary in the distribution? :-)
Regards,
Matt
- Original Message -
From: Sergei Golubchik
Sent: Monday, February 02, 2004 11:33 AM
Subject: Re: query the data of a fulltext index directly from index?
Hi!
On Feb 02, Alexander Bauer
Hi!
On Feb 02, Matt W wrote:
Sergei,
Any chance of getting a ft_dump Windows binary in the distribution? :-)
Chances are good :)
It was added to rpms and binary unix distributions 5 min ago,
and it should be added to windows distro too.
Note - the new name is myisam_ftdump.
Regards,
Is there any plan to introduce FULLTEXT indices under InnoDB table
types?
Regards,
Hassan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hassan Shaikh [EMAIL PROTECTED] wrote:
Is there any plan to introduce FULLTEXT indices under InnoDB table
types?
Full-text search is in the InnoDB TODO list:
http://innodb.com/todo.html
But it's a long-term goal.
--
For technical support contracts, goto
At 08:51 AM 2/2/2004, you wrote:
Hassan Shaikh [EMAIL PROTECTED] wrote:
Is there any plan to introduce FULLTEXT indices under InnoDB table
types?
Full-text search is in the InnoDB TODO list:
http://innodb.com/todo.html
But it's a long-term goal.
If anyone has the cash to sponsor the
Hello,
is there any way to get the fulltext index contents directly? I'm looking
for a way to list all indexed words from a column to provide a filter
selection.
How can I access the index data without walking through all table rows, get
the column and tokenize and collect words?
Thanks,
Alex
In the last episode (Feb 02), Alexander Bauer said:
Hello,
is there any way to get the fulltext index contents directly? I'm looking
for a way to list all indexed words from a column to provide a filter
selection.
How can I access the index data without walking through all table rows, get
Hi!
On Feb 02, Alexander Bauer wrote:
Hello,
is there any way to get the fulltext index contents directly? I'm looking
for a way to list all indexed words from a column to provide a filter
selection.
How can I access the index data without walking through all table rows, get
the column
Fellow Mysqlians,
Can anyone tell me why mysql refuses to use the fulltext index
in the second query?
Query 1;
mysql explain select straight_join distinct i.ID from INTEREST i use index
(COMMENT)
inner join PERSON p on p.ID=i.PERSON_ID where match(i.COMMENT)
against
Hi,
I have error 1191 can't find fulltext index matching the column list,
but I am certain that all columns in the list are present in my Fulltext
index. Does anybody else had this problem? I am using 4.1.0.
thanks,
Mirza
--
MySQL General Mailing List
For list archives: http
If you do a fulltext search on multiple columns at once, there must be a
combined fulltext index on this exact set of columns. Just having an index
on them individually will not work.
On Wed, 3 Dec 2003, Mirza wrote:
Hi,
I have error 1191 can't find fulltext index matching the column list
Mirza [EMAIL PROTECTED] wrote:
I have error 1191 can't find fulltext index matching the column list,
but I am certain that all columns in the list are present in my Fulltext
index. Does anybody else had this problem? I am using 4.1.0.
Show your table structure and query, please
Hi! I'm going to use the fulltext index in an multilingual product and need to
modify/translate the stopword list. According to the documentation:
The stopword list can be loaded from the file specified by the ft_stopword_file
variable. See section 4.5.7.4 SHOW VARIABLES. Rebuild your FULLTEXT
: Peter Björkman
Sent: Monday, October 13, 2003 8:49 AM
Subject: Fulltext index, stopword list changes
Hi! I'm going to use the fulltext index in an multilingual product and
need to modify/translate the stopword list. According to the
documentation:
The stopword list can be loaded from the file
Hi!
On Oct 07, Dathan Vance Pattishall wrote:
I have to drop the FULLTEXT INDEX added to a set of dbs containing a
TEXT field with an average of 6K of text added to each row, at a growth
of 250K rows added a day to a set of 100 tables. The reason for the drop
is due to table corruption
I have to drop the FULLTEXT INDEX added to a set of dbs containing a
TEXT field with an average of 6K of text added to each row, at a growth
of 250K rows added a day to a set of 100 tables. The reason for the drop
is due to table corruption and non-related query slowdown.
DELETES and Frequent
Sergei Golubchik wrote:
On Sep 06, Andreas Schwarz wrote:
Egor Egorov wrote:
Andreas Schwarz [EMAIL PROTECTED] wrote:
is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2)
fields in 4.1?
Nope. Fulltext search doesn't work with multi-byte character sets.
Will this
Egor Egorov wrote:
Andreas Schwarz [EMAIL PROTECTED] wrote:
is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2)
fields in 4.1?
Nope. Fulltext search doesn't work with multi-byte character sets.
Will this be fixed in future versions? Otherwise I would have to
do the
At 11:25 + 9/6/03, Andreas Schwarz wrote:
Egor Egorov wrote:
Andreas Schwarz [EMAIL PROTECTED] wrote:
is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2)
fields in 4.1?
Nope. Fulltext search doesn't work with multi-byte character sets.
That's correct. It's documented at:
Hi!
On Sep 06, Andreas Schwarz wrote:
Egor Egorov wrote:
Andreas Schwarz [EMAIL PROTECTED] wrote:
is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2)
fields in 4.1?
Nope. Fulltext search doesn't work with multi-byte character sets.
Will this be fixed in future
Hello,
is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2)
fields in 4.1?
Andreas
--
AVR-Tutorial, über 350 Links
Forum für AVRGCC und MSPGCC
- http://www.mikrocontroller.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Andreas Schwarz [EMAIL PROTECTED] wrote:
is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2)
fields in 4.1?
Nope. Fulltext search doesn't work with multi-byte character sets.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
%' and not MATCH(...) AGAINST(...)?
Matt
- Original Message -
From: Mark [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 03, 2003 6:35 PM
Subject: Re: keeping a fulltext index in memory
Any chance you OS swapped out part of your key_buffer? See if any
of
mysqld's memory
Any chance you OS swapped out part of your key_buffer? See if any
of
mysqld's memory is sitting in swap.
Jeremy
Hi,
how exactly do I tell this on linux?
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
I'm having problems with a fulltext indexed table where it takes a
long time return from a query where many rows match. I noticed that
when I run a query like
select count(*) from table where keywords like '%x%';
it takes a long time but after that all fulltext queries are much
faster, I'm
On Tue, Sep 02, 2003 at 11:45:21AM -0700, Mark wrote:
Hi,
I'm having problems with a fulltext indexed table where it takes a
long time return from a query where many rows match. I noticed that
when I run a query like
select count(*) from table where keywords like '%x%';
it takes a long
Hi,
I've created some fulltext indexes and would like to
know the size in bytes of each one.
Someone would please help me on that?
Thanks in advance!
Cleber Melo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
with about 400 records.
As you can tell, every record is about 4MB, all of which is
text.
I've created a fulltext index on the table, with
alter table table2002 add fulltext data (data);
After this is done (takes about 20 minutes to do) I check
out the index size, which is 8,722 KB...
If I do
Hello All.
I have a table that is about 1.5GB with about 400 records.
As you can tell, every record is about 4MB, all of which is
text.
I've created a fulltext index on the table, with
alter table table2002 add fulltext data (data);
After this is done (takes about 20 minutes to do) I check
out
is about 4MB, all of which is
text.
I've created a fulltext index on the table, with
alter table table2002 add fulltext data (data);
After this is done (takes about 20 minutes to do) I check
out the index size, which is 8,722 KB...
If I do a fulltext search against this table, it takes about
...
It dawned on me that perhaps the problem had to do with double-byte
characters,
What language is this text in? Is it by chance a language that does not
use whitespace to delimit words?
--
Joel Rees [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives:
and myisam_max_sort_file_size
to a size appropriate for the size of your table. Double check
that you have enough disk space.
In my case I could reduce the time needed to create a fulltext index from
18 hrs to a few minutes.
Thomas Spahni
On Sun, 23 Mar 2003, Nick Arnett wrote:
-Original Message-
From
Hi!
On Mar 23, Nick Arnett wrote:
I'm trying to create a full-text index on a large (2.1GB, 1.6M records), two
column table (primary key and a TEXT field), using MySQL 4.0.12 on Win2000.
All looks like it is proceeding well, I see .TMP files in the database
directory and a couple of temporary
I'm trying to create a full-text index on a large (2.1GB, 1.6M records), two
column table (primary key and a TEXT field), using MySQL 4.0.12 on Win2000.
All looks like it is proceeding well, I see .TMP files in the database
directory and a couple of temporary files in TEMP. It chugs along for an
1 - 100 of 161 matches
Mail list logo