On Mon, 2006-08-07 at 09:18 +0100, [EMAIL PROTECTED] 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/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]