Alex Heiphetz writes:
> Hi:
>
> I got error 2008 trying to run a simple query on a large database
> (query was something like:
> mysql> Select * from catalogue where price<3.00;
> Database consists of 280,000 rows, in text form it's 37 MB of data)
>
> Question:
> manual recommends using
> mysql --quick (or mysql_use_result() in C API) to circumvent this.
> I have a program that uses seek_data(), so, unfortunately, this won't
> work for me. Is there any other way? I.e. increase available memory :-)
> I'm running this on PII-400 with 128 MB of RAM. There are no other
> memory/CPU hungry processes running on this box.
>
> Thanks in advance,
> A.Heiphetz
>
Hi!
Please report on the version and distribution of MySQL, on the make
and version of OS and on the versions of C and thread libs.
Before that, run isamchk -o on the catalogue table.
May be it is corrupt.
Sinisa
+---------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Belgrade |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Serbia |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+---------------------------------------------------------------------+
