On 04 Sep 2007, at 22:11, Kevin wrote:
So I keep getting this mysql error:
ERROR 5 (HY000) at line 41: Out of memory (Needed 1404208 bytes)
It occurs when I do a INSERT INTO table SELECT from other table ON
DUPLICATE
KEY UPDATE statement.
The two table in the above commands have about 350,000 rows each.
I've tried
dumping the database and reloading it. The only real thing I've
been able to
figure out it that an error 5 in mysql is an operating system I/O
error.
There's plenty of disk space and memory. I've been pulling my hair out
trying to solve why its doing this. I'm running out of ideas on
what to do.
Anybody have an idea on what might be the fix?
My first guess was system resources, but if you have plenty of those
my next guess would be MySQL settings. Perhaps MySQL has a memory
limit and your query is exceeding that. You might want to hop on IRC
and join channel #mysql or hit up the mysql mailing list.
Jonathan
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
