MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Peter Zaitsev Date:August 7 2006 8:28am
Subject:Re: maximum files size for longblob - what is bigger?
View as plain text  
On Mon, 2006-08-07 at 09:18 +0100, ross@stripped wrote:
> what us the maximum filesize for longblobs in kb? Is there anything bigger?

http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

As you can see in theory it is about 4GB.

It is however also limited by max_packet_size which is 16M by default. 

I would be very careful using blobs larger than 100MB.   MySQL will need
some 3 times of this size of memory allocated on the server for blob
processing. 



-- 
Peter Zaitsev,  MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Thread
maximum files size for longblob - what is bigger?ross7 Aug
  • Re: maximum files size for longblob - what is bigger?Chris7 Aug
  • Re: maximum files size for longblob - what is bigger?Peter Zaitsev7 Aug