List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:March 16 1999 12:20am
Subject:Err. 2008 and how to fight it :-)
View as plain text  
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   |
+---------------------------------------------------------------------+
Thread
Err. 2008 and how to fight it :-)Alex Heiphetz15 Mar
  • Err. 2008 and how to fight it :-)sinisa16 Mar