20 messages in com.mysql.lists.javaRe: >64k blobs
FromSent OnAttachments
Joerg Brunsmann09 Jun 1999 09:37 
Michael Widenius09 Jun 1999 11:11 
Joerg Brunsmann09 Jun 1999 13:21 
Michael Widenius09 Jun 1999 13:28 
Ambrose Li [EDP]09 Jun 1999 13:30 
Joerg Brunsmann09 Jun 1999 13:38 
candide09 Jun 1999 13:43 
"Terrence W. Zellers"09 Jun 1999 19:07 
Mark Matthew09 Jun 1999 19:53 
Mark Matthew09 Jun 1999 19:56 
Joerg Brunsmann10 Jun 1999 01:31 
Michael Widenius10 Jun 1999 01:49 
Joerg Brunsmann10 Jun 1999 03:26 
Joerg Brunsmann10 Jun 1999 05:40 
Mark Matthew10 Jun 1999 05:59 
Joerg Brunsmann10 Jun 1999 06:10 
"Terrence W. Zellers"10 Jun 1999 17:20 
"Terrence W. Zellers"10 Jun 1999 18:45 
Joerg Brunsmann11 Jun 1999 05:37 
Cris Perdue11 Jun 1999 09:43 
Subject:Re: >64k blobs
From:Michael Widenius (mon@monty.pp.sci.fi)
Date:06/09/1999 01:28:44 PM
List:com.mysql.lists.java

"Joerg" == Joerg Brunsmann <Joer@FernUni-Hagen.de> writes:

Joerg> Hi,

How big blobs are you using? Your max_allowed_packet is 1M, which means that you can't insert bigger blobs than 1M.

Joerg> Actually and unfortunately they are 130k and 120k, definitely Joerg> beyond the 1M mark. Just a stupid thougth: is it possible that Joerg> altering from blob to longblob online could be a problem?

Not, the alter table should have worked. You can check the table with isamchk to verify thats it's ok.

Can you try running mysqld with --loge to verify that the query is sent to the mysqld server ?

Joerg> Thanks,

Joerg> Joerg

Regards, Monty