Hello MySQL fellows,
The problem was solved after rebuilding all indices on the table by
using the table repair function.
I noticed the problem after the application returned an error issued by
MySQL that the table.myd file
was missing or corrupted.
Nevertheless, I don't know how that happened, th
I am importing a file into a table in which I want it to ignore
duplicate rows. When I specify --ignore (this also happens if I do a
SELECT IGNORE INTO from the client also) I get a duplicate key error. If
I run the command again it skips the first such instance of a duplicate
key and gives me
Ian, based on your needs (regularly deleting everything morre than X
months old), I recommend you look into using the MERGE engine.
Essentially, it is multiple MyISAM tables that appear as one, and
lopping off the oldest data is as simple as redfining the MERGE and
then dropping the oldest table.
Another way to do it would be to select the data you want to keep into a
table on another file system, truncate the existing table, optimize it, then
reload it with the data you saved.
I can't say that I've tried this, and have no idea how long it would take or
even if it would work.
Regards,
Je
Hi,
We are looking at various methods that we can effectively and efficiently
delete lots of rows from a database and then optimize it. Our main concern
is disk space - the partition we are working with is only 12gigs small and
our database vary in size from 1gig (not a problem) to 11gig. In the
Sorry, I have no idea what is going wrong.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Andreas Iwanowski [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 01, 2007 2:22
Hi, thank you for your reply.
I have used the option ft_min_word_len=3.
If I have something like
1. "Key West"
in the database and I do a
SELECT * FROM my_table WHERE MATCH(Keywords) AGAINST ('Key' IN BOOLEAN
MODE)>0;
then I don't get any results either.
If I leave the quotation marks away, I f
Unless you changed the minimum word length, "Key" would be ignored because
it is too short. I would think the quotation marks at the start or end of
the words would be ignored. The asterisk operator is only valid at the end
of a word. Those initial asterisks, and the quotation marks, would be
treat
In the last episode (Feb 01), Jim C. said:
> Is it possible to dump to the old MySQL 4.x format? There are some
> conversion tools I would like to use and they don't support 5.0 yet.
mysqldump --compatible=mysql40 ; see the mysqldump manpage for all the
options.
--
Dan Nelson
[E
Is it possible to dump to the old MySQL 4.x format? There are some
conversion tools I would like to use and they don't support 5.0 yet.
Jim C.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello MySQL experts,
I'm trying to do a full text search on an indexed Keywords column that
contains quotation marks, and it's giving me a headache.
Suppose there are records in the database containing the folling
keywords:
1. "Miami Beach" City
2. "Key West" Florida
3. "Key West" Beach Florida
This also works...
SELECT name
FROM people AS p
JOIN people_city_map AS pcm ON (p.id = pcm.pid)
WHERE pcm.cid = 1;
Not sure if it is any faster (or better) than what Chris suggested but
it seems to be faster on my machine.
Randall Price
Secure Enterprise Technology Initiatives
Microsoft Im
This isn't exactly what I was looking for, but it works like a charm for
both my needs and the sys admins.
Go figure everyone is happy now!
Many Thanks!
-Tyler
Kishore Jalleda wrote:
The delete would definitely depend upon the size of the record set being
deleted, anyway assuming I comprehen
Hello Michael. Here is the query you wanted - you were almost there.
SELECT DISTINCT NAME FROM PEOPLE
WHERE ID IN
(SELECT PID FROM PEOPLE_CITY_MAP
WHERE CID = 1)
Thanks.
-Original Message-
From: Michael Fischer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 31, 2007 11:53
Hi.
Using mySQL v4.1.9 on Fedora Core 2, I'm suffering a shutdown everyday
around 04:30. These are the contents of 'mysqld.log':
/usr/sbin/mysqld: ready for connections.
Version: '4.1.9-standard-log' socket: '/var/lib/mysql/mysql.sock'
port: 3306 Source distribution
070201 4:29:40 [Note]
Hi,
I know about CONVERT but I wanted to check character set of 'tt' column
and this result use in CONVERT. Something like CONVERT(id USING
CHARSET(Name))
which doesn't work.
It wont. the syntax is -- CONVERT(expr USING transcoding_name); its the
name of the transcode and not an expr.
I j
I know about CONVERT but I wanted to check character set of 'tt' column
and this result use in CONVERT. Something like CONVERT(id USING
CHARSET(Name))
which doesn't work.
I just wonder why CONCAT(1, ',', Name) works OK even if CHARSET(1) is
binary string and CONCAT(id, ',', Name) doesn't
Th
Hi,
It is that, what you think a binary is ,...is indeed a binary.
As per the manual, If a string input or function result is a binary string,
the string has no character set or collation.
so the resultant 'binary' is expected.
if u want the resultant as:
mysql> select charset(concat(tt,CONVE
Hi,
If you want to round your value to the specified no. of digits, use round().
Else if you want to extract the values without rounding use truncate().
mysql > select round(blustat,2) from parts; [the value will get rounded to
the nearest decimal]
or
mysql > select truncate (blustat,2) fro
19 matches
Mail list logo