Large tables on FreeBSD

2002-05-14 Thread Ovanes Manucharyan
Hello, I need to create a table that is around 15 GB on a FreeBSD 4.5RELEASE system. I compiled mysql-3.23.49 without any extraneous flags such as (--disable-largefile) I use mysqlimport to import the table from a flatfile which is about 9GB. I watch the .MYD file grow to about 4.2 GB and stop

Comparing text documents

2001-12-01 Thread Ovanes Manucharyan
I have lots of text documents archived in a mysql database. I need to compare these documents to see which ones are similar (either they may have a small formatting difference or have a word or two different). Is there a function/method in mysql that will easily accomplish this? If not could you s

Re: Problem compiling MySQL 4.0.0 on FreeBSD 4.0-RELEASE

2001-11-18 Thread Ovanes Manucharyan
Mysql placed the libmysqlclient.so.10 in /usr/local/lib/mysql and thus out of my search path. A quick and dirty fix was to create a symlink from /usr/local/lib Ovanes On Sun, 18 Nov 2001, Dan Nelson wrote: > In the last episode (Nov 18), Ovanes Manucharyan said: > > Thanks, I tried

Re: Problem compiling MySQL 4.0.0 on FreeBSD 4.0-RELEASE

2001-11-18 Thread Ovanes Manucharyan
. I thought that building mysql with the --enable-shared should have created the right files, however, udmsearch's indexes is still complaining about this file. Thanks in advance. Ovanes P.S. Please excuse my newbie-ness On Sun, 18 Nov 2001, Dan Nelson wrote: > In the last episode (No

Problem compiling MySQL 4.0.0 on FreeBSD 4.0-RELEASE

2001-11-18 Thread Ovanes Manucharyan
Hi, I have a problem compiling MySQL on FreeBSD 4.0-RELEASE. ./configure --with-libwrap --enable-shared and this is what I get. {...} gcc -DHAVE_CONFIG_H -I. -I../.././innobase/pars -I.. -I../.././innobase/pars/../ include -I../.././innobase/pars/../../include -I../../include-DDBUG_OFF

Fulltext search for 2 words close to each other

2001-03-25 Thread Ovanes Manucharyan
Hello, I am trying to search for 2 words which are close to each other.. In fact, its a name so it should either occur as John, Doe or John Doe in my fulltext index.. (this particular table is full of emails) select id,message_subject from email WHERE MATCH(message_body,message_subject) against