----- Original Message -----
> From: "Reindl Harald" <h.reindl@stripped>
> To: mysql@stripped
> 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.