full text search is different than pattern match. If
you want to return stef, you have to use pattern
match.
Qunfeng
--- "Steffan A. Cline" <[EMAIL PROTECTED]> wrote:
> Am I missing something on mysql full text search?
>
>
> I was using a simple statement like
> select firstname from contacts
.
Qunfeng
--- Frank Peavy <[EMAIL PROTECTED]> wrote:
> Qunfeng,
> ..millions of records.. seems like a lot...
> Would you be kind enough to provide me with your
> hardware configuration?
> Thanks.
>
>
> At 07:57 AM 12/31/02 -0800, Qunfeng Dong wrote:
> >If you are
olution. I thought that I might be able to use
> pattern matching as a
> substitute, but it sounds like performance might be
> an issue with large tables.
>
> If you have any other recommendations on how I could
> approach my problem, I
> would surely appreciate them.
>
It can perform pattern match on text field. The only
draw back is the speed (especially if you are using
%pattern% to do the search) when you tables are
getting huge, since there is no index to help.
Qunfeng
--- Frank Peavy <[EMAIL PROTECTED]> wrote:
> I would like to use pattern matching as a su
wing the "Duplicates"? They are NOT
duplicate because the count(*) with the whereclause
returns 0 records before the above "replace ...
select"
mysql> select count(*) from table2 where clause;
+--+
| count(*) |
+--+
|0 |
+--+
I am using mysql3.2
---+--
> ---+
> > | s | index | NULL | PRIMARY |
> 50 |
> > NULL | 2676711 | Using index |
> > | h | ref | PRIMARY | PRIMARY |
> 50 |
> > s.Seq_ID |9976 | Using index |
> >
>
+---+---+---+
replace missing value (NULL) as \N in your .txt file
--- Gianluca Carnabuci <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've been trying to import a huge .txt file into a
> MySql table. In the .txt file, missing values are
> recorded as empty cells (it might be that there's
> some hidden character inste
ning MySQL 3.23.49 on RedHat linux 7.3 on a
dedicated server with 4 GB memory. The only setting I
changed is to copy the my-huge.cnf into /etc/my.cnf.
Qunfeng
--- "Michael T. Babcock" <[EMAIL PROTECTED]>
wrote:
> Qunfeng Dong wrote:
>
> >not-so-good performance (join
_Homolog
(
Seq_ID varchar(50) NOT NULL,
Homolog_PID int NOT NULL,
Homolog_Descvarchar(50) NOT NULL,
Homolog_Species varchar(50),
PRIMARY KEY (Seq_ID, Homolog_PID)
);
--- "Michael T. Babcock" <[EMAIL PROTECTE
I am very encouraged to hear all these successful
proofs. I do want to stick to MySQL (we are using it
to develop a biology database). But I am indeed seeing
not-so-good performance (join on tables much smaller
than yours takes minutes even using index) and I seem
to read all the docs I could find
size
limit for file. MySQL seems to store each of its table
as single file. You need to choose a file system
without that limit.
Qunfeng Dong
--- "B.G. Mahesh" <[EMAIL PROTECTED]>
wrote:
>
> hi
>
> We are evaluating few databases for developing an
> application
chown -R mysql:mysql /home/medic/
and make sure there is no outfile.txt already in that
dir.
--- sam <[EMAIL PROTECTED]> wrote:
> I executed the following statement:
>
> SELECT * INTO OUTFILE '/home/medic/outfile.txt' FROM
> fool;
>
> I get the error meassge
>
> " Can't create/write to file
> '
I also got that msg and I did seem to receive all the
emails from the list.
Qunfeng
--- Bill Rausch <[EMAIL PROTECTED]> wrote:
> I just got a message from the ezmlm program telling
> me that the
> mysql digests have been bouncing and it is going to
> remove me from the list.
>
> In fact, the d
ment setting the index size
> to 20, 30, ...
>
> I hope this will give you some ideas on how you can
> improve performance.
>
> Regards,
> --
> Stefan Hinz <[EMAIL PROTECTED]>
> CEO / Geschäftsleitung iConnect GmbH
> <http://iConnect.de>
> Heeses
| rows| Extra |
+---++---+-+-+--+-+---+
| s | ALL| NULL | NULL|NULL |
NULL | 2684094 | |
| h | eq_ref | PRIMARY | PRIMARY | 50 |
s.Seq_ID | 1 | |
+---+----+--
umnb are varchar(11) and indexed.
Table B has about 34,000 records and Table A has about
2,500,000 records. The above query took about 3 hours
to finish. Something is just not right.
Qunfeng Dong
--- David Bordas <[EMAIL PROTECTED]> wrote:
> > I wish to tune our MySQL Server Par
Isn't NULL value in MySQL stored as '\N'? If so, you
can check that in your perl script.
Qunfeng
--- David Wu <[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> Running into a frustrating problem. When I have a
> empty table in mysql
> database, i tried run a select statement in my perl
> script and
-O sort_buffer=4M -O
read_buffer_size=1M &
My questions: if I run the above command (as root),
should I run it every time when the server starts? If
so, how can I set the above option automatically when
server starts. Thanks!
Qunfeng Dong
__
Hi, Can anybody give me a simple example of using
PHP's mysql_query to perform mulitple mysql queries. I
am using MySQl 3.23, trying to use create temporary
table and insert ... select to overcome the lack of
union operation in that verion of MySQL.
Thanks!Qunfeng
19 matches
Mail list logo
