----- Original Message ----- > From: "Reindl Harald" <h.rei...@thelounge.net> > To: mysql@lists.mysql.com > Sent: Monday, 26 May, 2014 11:56:26 AM > Subject: Re: blob data types > > > Am 26.05.2014 11:40, schrieb geetanjali mehra: > > I want to know where does MyISAM and innodb stores its BLOB data ; inside > > the table or outside the table. I tried to understand BLOB using MySQL > > online docs but failed. > > inside the table, it's just a field type
Didn't InnoDB store them out of line (but still inside the datafile, of course) ? I might be remembering wrong, though. You could design your application to store blobs in files instead; but you preferably also need to use redundant/shared storage, then. It's a common enough design, but it needs though and understanding :-) As a tangential thought, there was also a thirdparty plugin engine at some point that streamed blobs outside of the normal MySQL protocol. Can't remember the name. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
