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
