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" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]