Re: Very large BLOBS in MySQL 4.0.1

2002-04-05 Thread Martin Mokrejs
Adriano Manocchia wrote: Well, first off, I can't seem to get max_allowed_packet higher than 64 MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are reflected in the system settings, but only up to 64 MB, then regardless of what I put in there, it stays at 64 MB. But

Re: Very large BLOBS in MySQL 4.0.1

2002-04-01 Thread Adriano Manocchia
Well, first off, I can't seem to get max_allowed_packet higher than 64 MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are reflected in the system settings, but only up to 64 MB, then regardless of what I put in there, it stays at 64 MB. But like I said, the file is only

Re: Very large BLOBS in MySQL 4.0.1

2002-03-30 Thread Peter Zaitsev
Hello Adriano, Friday, March 29, 2002, 11:38:32 PM, you wrote: As I remember there are max_allowed_packet options exists both for client and server. You may wish to try to raise both of them. AM I've been using a perl script to insert a very large blob (up to about 8 AM MB) into a DB

Very large BLOBS in MySQL 4.0.1

2002-03-29 Thread Adriano Manocchia
I've been using a perl script to insert a very large blob (up to about 8 MB) into a DB successfully, but now I need to do it with a 34 MB BLOB, so I upgraded to MySQL 4.0.1. First off, I can't get max_allowable_packet to go higher than 64M, regardless of what I set it to, but that shouldn't

Re: Very large BLOBS in MySQL 4.0.1

2002-03-29 Thread Colin Faber
It sounds to me that you're exceeding the maximum packet size mysql can handle. Adriano Manocchia wrote: I've been using a perl script to insert a very large blob (up to about 8 MB) into a DB successfully, but now I need to do it with a 34 MB BLOB, so I upgraded to MySQL 4.0.1. First off,