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]