Hi.
On Tue 2002-07-23 at 14:58:16 -0400, [EMAIL PROTECTED] wrote:
> I have 14 fields are chars (like char(8), char(9)), and one field is int(4).
> All char fields are mixed with upper case letters, numbers(0-9) and
> sign(like $).
> Because there is no low case char, I don't have to put -f option for unix
> sort.
Well, it never hurts to try anyhow... *hint*
Does the query use indexes? If so, please check they are not corrupted
(e.g. using CHECK TABLE).
Which character set is MySQL set to, which "locale" is set in your
shell? Maybe the collections are different and consider different
characters the same.
Please try to find some rows which "disappear". For example, dump the
result from the query (62,000,000 rows) to a file like you have done
for the 76,500,000 rows and find out which rows got removed
(e.g. sorting the files and using "comm" on the 76,000,000 and
62,000,000 version).
In short, try to make a reproducable test case. Thanks.
Greetings,
Benjamin.
[...]
> >> >> I have a 76,500,000 rows table with 15 fields.
> >> >> I try to sort this rows on all fields, so I am using select all
> >fields1
> >> >> group by all fields2 or distinct all fields1 with order by all
> >fields2.
> >> >> After sort, I get 62,000,000 rows.
> >> >>
> >> >> Then I use Linux unique sort, I dump out 76,500,000 table and using
> >> >sort -u
> >> >> file1 -o file2.
> >> >> I got 76,000,000 rows.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
