Re: MAX_ALLOWED_PACKET and BLOBS
Hello everybody:
After a couple of weeks on a kind of nightmare I have finally found my problem. It was due to a bad use of transactions (I don't know wich one). After Disable all transactions I could upload and download the BLOBs using quite big buffers.
I have made a program to test the BLOB use wrapped by a transactions and everything goes right. It seems clear that this error is my fault but the MySQL behavior is quite odd, everithing works perfectly if my queries remains below 1024KB. I have to work on this.
After all, setting max_allowed_packet on my.ini solved my problem.
Thanks everybody for they effort's, specially to John Z.
Subject
Views
Written By
Posted
943
November 04, 2005 03:29AM
534
November 04, 2005 09:13AM
580
November 04, 2005 10:32AM
469
November 07, 2005 02:58AM
621
November 07, 2005 03:40AM
525
November 07, 2005 04:46AM
673
November 07, 2005 06:57AM
542
November 07, 2005 09:46AM
584
November 08, 2005 04:56PM
646
November 09, 2005 03:26AM
563
November 10, 2005 03:29PM
Re: MAX_ALLOWED_PACKET and BLOBS
609
November 18, 2005 01:20PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.