List:General Discussion« Previous MessageNext Message »
From:yoku ts. Date:May 26 2014 10:17am
Subject:Re: blob data types
View as plain text  
Hello,

I can see MyISAM stores BLOB column as same space as other data type
column,
but InnoDB doesn't. (If you mean "same .ibd file" it's true)

http://dev.mysql.com/doc/refman/5.6/en/innodb-row-format-overview.html

ROW_FORMAT= Compact holds first 768 bytes of BLOB column,
ROW_FORMAT= Dynamic or Compressed holds first 20bytes of column.

http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-compression-internals-storage-blobs.html



2014-05-26 18:56 GMT+09:00 Reindl Harald <h.reindl@stripped>:

>
> 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
>
>

Thread
blob data typesgeetanjali mehra26 May 2014
  • Re: blob data typesReindl Harald26 May 2014
    • Re: blob data typesgeetanjali mehra26 May 2014
      • Re: blob data typesReindl Harald26 May 2014
    • Re: blob data typesyoku ts.26 May 2014
    • Re: blob data typesJohan De Meersman26 May 2014