Hi. Not sure if this will help, but is your default table type MyISAM?
At http://bugs.mysql.com/bug.php?id=563 is the following:
Quote:
[27 Aug 8:00pm] Michael Widenius
Short update regarding this.
I just found a memory overflow bug in the MyISAM handler in the case where one had many fields and at least one TEXT or BLOB field. MySQL 4.0.14 already fixed a similar bug regarding INSERT's but unfortunately we missed one case with UPDATE.
This is now fixed in in our repsitory and the fix will be in 4.0.15, which we are already doing relese-testing on and it should be out shortly.
Hopefully this will solve the issues reported in the bug report.
If you can't wait for 4.0.15, you should be able to solve this by converting your tables to InnoDB tables.
Regards,
Monty
|
MySQL 4.0.15 has been released. Downloads can be found at http://www.mysql.com/downloads/mysql-4.0.html
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.
|