View Single Post
Old 02-23-2009, 10:26 PM  
FreeHugeMovies
Too lazy to set a custom title
 
Join Date: Dec 2001
Location: Charlotte, NC
Posts: 14,137
Quote:
Originally Posted by masterwebmonkey View Post
MySQL supports BLOBs (Binary Large Objects), which means you can store any binary file into MySQL. Many people ask, what is the maximum size of a BLOB in MySQL.

The theoretical limit in MySQL 4.0 is 2G, however each blob requires generally to have 3 copies of it in the memory (stored in various buffers) so you need a lot of memory, if you have large BLOBs stored in MySQL. This is the reason, why the theoretical limit can be reached only on 64bit systems. The Practical limits are around some hundreds of megs per BLOB.
You lost me after MySQL
FreeHugeMovies is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote