Trevor Linton writes:
> I'm researching whether it is possible to store large amounts (30-70MB
> files) into mysql columns.  It looks as if a LONG BLOB could handle this,
> however I read that the communications buffer size can only support up to 16
> MB transfers.  It also said that you could increase the size of the buffer,
> however it never said the name of the variable setting to change to do this.
> This server is a monster, and memory and disk space are not a problem, If I
> can increase the "message buffer" will this allow me to store between
> 30-70MB files into these LONGBLOB fields?
> 
> I know it seems like I should just store them into the file system but the
> application at hand needs them in a database (please don't make me explain
> why :-) ). Does anyone know whether MySQL is powerful enough to handle this
> amount of data in a single column?  Are there any other special
> considerations I should take in with doing this?
> 
> Thanks,
> Trevor
> 
> Trevor F. Linton
> Systems Administrator/Web Developer
> Vérité Multimedia Inc.
> http://www.verite.com
> DVD * CD * Web * Print * Film * Sound
> Phone: 801.553.1101 x 111
> Fax: 801.553.1215
> [EMAIL PROTECTED]
> 
> 


Maximum size of a row is limited in 3.23 by maximum value of
max_allowed_packet, which is 16 Mb. This is maximum value due to
current client - server protocol limitations. 

This limit is already increased in 4.0 to 4 Gb. 4.0 will be available
next month. 

-- 
Regards,
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
       <___/   www.mysql.com


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to