List:General Discussion« Previous MessageNext Message »
From:nocturnal Date:December 1 2006 10:12am
Subject:Re: +1MB query gets "Out of memory"
View as plain text  
Hi

The -q argument has already been tried but it did not work so well. I've 
told the client to increase the packet_size on their side now but i 
haven't received word on if it worked or not.



Med vänliga hälsningar

Stefan Midjich aka nocturnal
[Swehack] http://swehack.se


Visolve DB Team wrote:
> Hi,
> 
> Hope query_cache does not relate with the error. Because, if the query 
> is larger than the query_cache size, automatically that will not be 
> cached.  So that query, on executing any no of times, will never utilize 
> the cache.
> Also as of our understanding, packet_size does not produce out of memory 
> error.
> 
> Try with,
> Invoke mysql with the --quick option. This causes it to use the 
> mysql_use_result() C API function to retrieve the result set, which 
> places less of a load on the client (but more on the server).
> Ref: http://dev.mysql.com/doc/refman/5.0/en/out-of-memory.html
> 
> Thanks
> ViSolve DB Team
> ----- Original Message ----- From: "nocturnal" <nocturnal@stripped>
> To: <mysql@stripped>
> Sent: Thursday, November 30, 2006 9:11 PM
> Subject: +1MB query gets "Out of memory"
> 
> 
>> Hi
>>
>> A client used to get Out of memory when trying to send a query that 
>> was a bit more than 1MB. The problem was solved when i increased 
>> query_cache to 2MB but now the problem is back and this time the line 
>> reported by the Out of memory error has a query that is just a bit 
>> over 1MB again. The only other value i could find that was 1MB was 
>> packet_size but that didn't help.
>>
>> What could i do to run this query?
>> -- 
>>
>>
>>
>> Med vänliga hälsningar
>>
>> Stefan Midjich aka nocturnal
>> [Swehack] http://swehack.se
>>
>> -- 
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: 
>> http://lists.mysql.com/mysql?unsub=1
>>
> 
> 
> 
Thread
+1MB query gets "Out of memory"nocturnal30 Nov
  • Re: +1MB query gets "Out of memory"Gerald L. Clark30 Nov
  • Re: +1MB query gets "Out of memory"Visolve DB Team1 Dec
    • Re: +1MB query gets "Out of memory"nocturnal1 Dec