List:General Discussion« Previous MessageNext Message »
From:Jay J Date:December 8 1999 1:16pm
Subject:Re: probem with Id In (...)
View as plain text  
----- Original Message -----
From: "Philips" <philips_at_work@stripped>
To: <mysql@stripped>
Sent: Wednesday, December 08, 1999 7:07 AM
Subject: probem with Id In (...)


>
> There's problem in following query (MySQL 3.22.25 under Caldera OpenLinux
2.2):
>
> SELECT News.*, Text.Text ,DATE_FORMAT(News.Date,'%m.%d.%Y %H:%i:%S') as
Date_Formated FROM News,
> Text WHERE News.Id in
>
(2708,2647,2637,2609,2598,2554,2499,2724,2728,2729,2751,2753,2775,2782,2814,
2817,2823,2826,2839,2855,2875,2885,2887,2888,2905,2976,3017,3022,3042,3044,3
341,3430,3446,3449,3450,3451,3500,3524,3529,3568,3569)
>
> When I try to execute this one (Text and News tables have ~ 7k rows,
program - some kind of search
> engine) MySQL starts to permanently allocate big amounts of memory.
Everything is crashing due to
> the memory lack and I have to 'Reset' my computer. Sometimes I have enough
time (and CPU time too :)
> before crash and I run 'kill mysqld', that kills nasty mysqld.
>
> Any advices how to avoid this situation? Any workaround?

My only guess is that "text" is a reserved word.

I use queries similar to that (and have tested with 1000's of values in IN
in 3.22.21 & 3.22.23b) without any problems.

-Jay J

Thread
probem with Id In (...)Philips8 Dec
  • Re: probem with Id In (...)Jay J8 Dec