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]