It looks perfect.
Thanks
Google for "myisam_ftdump", HTH Cor
- Original Message - From: "Sebastien Moretti"
To:
Sent: Thursday, April 23, 2009 5:24 PM
Subject: How to show highly frequent words in fulltext index ?
Hi,
Is there a command to see which words ar
Yes,
you can use myisam_ftdump
Bye
On Thu, 23 Apr 2009 17:24:09 +0200, Sebastien Moretti
wrote:
> Hi,
>
> Is there a command to see which words are highly frequent in a fulltext
> index ?
>
> Thanks
>
> --
> Sébastien Moretti
>
>
> --
> MySQL General
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
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 AND
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
> -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 sphi
Hi
Is sphinxsearch avialable only on for windows
regards
anandkl
On 6/13/08, Rory McKinley <[EMAIL PROTECTED]> wrote:
>
> mos wrote:
>
>
>> 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.sphinxsea
mos wrote:
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
I have read about sphinx and the good performance boost it provides -
unfortunately there is a lot of legacy code
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. The
>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
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,
Hi Jerry
Thanks for the explanation.
So, in short, I am most likely hitting a wall with the fulltext index,
and I am just
>-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
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 and
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 ad
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.
T * FROM item WHERE MATCH (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 FULLTEX
RE MATCH (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 tabl
rod_description` (`prod_description`)
) TYPE=MyISAM AUTO_INCREMENT=3367 ;
When I tried this:
SELECT * FROM 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_descrip
AM AUTO_INCREMENT=3367 ;
When I tried this:
SELECT * FROM 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 thi
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.
Tha
>>> PRIMARY KEY (`prod_id`),
>>>> UNIQUE KEY `prod_no` (`prod_no`),
>>>> KEY `products_index1` (`prod_status`),
>>>> KEY `products_index2` (`prod_start_date`,`prod_end_date`),
>>>> KEY `on_sale` (`on_sale`),
>>>> FULLTEX
7;);
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 need a single FULL
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".
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]
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
AUTO_INCREMENT=3367 ;
>>
>> When I tried this:
>> SELECT * FROM products
>> WHERE match (prod_name) against ('+red +shirt');
>> I'll get some results.
>> But, when I tried this:
>> SELECT * FROM products
>> WHERE match (pr
ch (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
What am I
FROM 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 FULLT
ch (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
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 featur
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]
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 tes
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 |
Ex
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
noDB 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? A
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
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 opti
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 f
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 correct?
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?
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 alterna
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 alterna
> > > 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 a
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
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 Inn
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
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 unsubscr
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
strange
problem, 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
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
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
or reference.
Hope that helps.
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
&
>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 q
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 pretty tiny.
ain, this is 4.0.18-max on AMD64. Only INSERTs ... UPDATE and DELETE
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 t
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&quo
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 typ
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
have you checked the error 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
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.
> The indexing starts and runs
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 | u
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
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 to
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!
>
> O
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,
>
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,
Ser
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
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
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,
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 t
"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 https://order.mysql.
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]
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)
agai
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 yo
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
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
l Message -
From: "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 s
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. Re
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 tabl
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
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 th
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:
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
d
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 s
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:http
KE
'%word%' 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
>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:http://lists.mysql.com/
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
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 not
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 PROT
e 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 t
; 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
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)
> ...
> 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: http://lists.mys
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 tempor
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-
&g
> -Original Message-
> From: Nick Arnett [mailto:[EMAIL PROTECTED]
> Sent: Sunday, March 23, 2003 1:39 PM
At the risk of talking to myself too much... I've tried creating a table
that has about 100 records with lots of characters with ASCII > 126 and have
no problem bu
1 - 100 of 167 matches
Mail list logo
