Hi!
On Jun 13, H M Kunzmann wrote:
> The answer is that a fulltext index can only be built on
> a TEXT field. Even though the mysql documentation describes
> MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
> they can not be used.
No, this is wrong.
Any xxxTEXT field can be
The answer is that a fulltext index can only be built on
a TEXT field. Even though the mysql documentation describes
MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
they can not be used.
On Thu, 2003-06-05 at 09:59, H M Kunzmann wrote:
> Hello All.
>
> I am using Redhat
> > When mysql is indexing You can check your data file direcory and You
> > ca see that one file (the index) is growing in size.
> I see it grow up to 8M and it stays there.
Watching this, it grows very slowly. After 5 minutes of indexing, the
file size has barely hit 2MB.
> > The command I use
> I think your index is corrupted because I expect a 1.5 GB index and not 8M!
> You can see word list wit a utility (sorry I don't remember te name ft_dump).
I agree with this :-)
> I suggest You to drop fulltext index, duplicate database and remove
> some rrecords.
> Then create index index aga
help needed. Please somebody
help.
I think your index is corrupted because I expect a 1.5 GB index and not 8M!
You can see word list wit a utility (sorry I don't remember te name
ft_dump).
I suggest You to drop fulltext index, duplicate database and remove
some rrecords.
Then create index
I think your index is corrupted because I expect a 1.5 GB index and not 8M!
You can see word list wit a utility (sorry I don't remember te name ft_dump).
I suggest You to drop fulltext index, duplicate database and remove
some rrecords.
Then create index index again.
Some questions:
Do You have d
Hello All.
I am using Redhat 9.0 with MySQL 4.0.12-0.
I've hit something of a dead-end with fulltext searching and I don't
know where to look next.
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 fullte
Charles Kline wrote:
I am fairly new to SQL and this is a really complex query for me.
Possibly more complex than necessary. Must you have a separate column
for each of the areas? If you don't mind having them all in a single
column, the query becomes simple and efficient:
SELECT p.fname, p.lna
Hi all,
I am fairly new to SQL and this is a really complex query for me.
Here is the setup. 3 tables. tbl_personnel, tbl_personnel_dras, tbl_dra
each person in the tbl_personnel table can have 0 - 3 records in the
tbl_personnel_dras table. The tbl_personnel_dras table is just the
person_id (fro
On Sunday 05 January 2003 09:08, Anton Zavrin wrote:
> Well, I read, played around and updated it (I guess)
> Now, when I try to start mysql with this command (same as before), it
> gives me that:
> # /usr/local/bin/safe_mysqld --user=mysql &
> [1] 71491
> # Starting mysqld daemon with databases f
<[EMAIL PROTECTED]>
To: "'Stefan Hinz, iConnect (Berlin)'" <[EMAIL PROTECTED]>; "'Thomas
Spahni'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 2003 8:08 AM
Subject: RE: MySQL Help Needed Please
Well, I read,
Saturday, January 04, 2003 2:14 PM
To: Anton Zavrin; 'Thomas Spahni'
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Help Needed Please
Anton,
>ps -ef | grep mysqld
>got nothing
Because the MySQL SERVER isn't running!
>Though I can do:
># mysql -u root -p
With this command,
t (Berlin)'" <[EMAIL PROTECTED]>; "'Thomas
Spahni'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 04, 2003 9:59 PM
Subject: RE: MySQL Help Needed Please
Did:
ps -ef | grep mysqld
got nothing
Though I can do:
# mysql -u root -p
E
Connect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 04, 2003 8:01 AM
To: Anton Zavrin; 'Thomas Spahni'
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Help Needed Please
Anton,
first thing, try:
ps [whatever options] | grep mysqld
The daemon (database server) is called my
70948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Anton Zavrin" <[EMAIL PROTECTED]>
To: "'Thomas Spahni'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 04, 2003 9:01 AM
Subject: RE: MySQL Help Needed Please
> I
ailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 7:01 AM
To: Anton Zavrin
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Help Needed Please
Anton,
check the .err and .log files in your data
directory.
Then check permissions. My sock file looks like:
srwxrwxrwx1 mysqldaemon 0 Dez
Anton,
check the .err and .log files in your data directory.
Then check permissions. My sock file looks like:
srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock
and finally check for your
socket= /tmp/mysql.sock
entries in /etc/my.cnf and ~/.my.cnf
Thomas Spahn
Hi guys,
I'm new here and need help.
I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed
but when I'm trying to run it says:
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)' Check that mysqld is running and that the
socket: '/tmp/mysql.sock' ex
On 26-Aug-2001 [EMAIL PROTECTED] wrote:
> Hi
>
> I need to set the max_allowed_packet to 16M. below is my
> 01mysql-server.sh file. I use DBI and I know that I have to start this
> before the DBI program and I did but if I use ./mysqld --help it shows
> that my max_allowed_packet is still 1M. An
Hi,
use "mysqladmin variables" command to see current settings. I guess
your mysqld does not read the config file you have edited. ;-) It
happened to me me also few days ago. Remember mysqld looks for
/etc/my.cnf and $DATADIR/var/my.cnf if I remember well. Maybe put the
path to config file just
Hi
I need to set the max_allowed_packet to 16M. below is my
01mysql-server.sh file. I use DBI and I know that I have to start this
before the DBI program and I did but if I use ./mysqld --help it shows
that my max_allowed_packet is still 1M. Any help would be really great
since I've been working
21 matches
Mail list logo