GoFuckYourself.com - Adult Webmaster Forum - View Single Post

masterwebmonkey · 02-23-2009, 10:22 PM

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.

02-23-2009, 10:22 PM
masterwebmonkey Registered User Join Date: Feb 2004 Posts: 93	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. __________________ Programmer looking for work you can hit me here -> Master Web Monkey or ICQ 281945544 PHP mySQL Flash ActionScript3 html javascitpt PERL::MECINIZE expect NATS MPA3 Responsys Interact