- Original Message -
> From: "Reindl Harald"
> 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 tabl
just don't store large binary data in tables
save the files somewhere in the application
and keep only references to the files in
the database
Am 26.05.2014 12:11, schrieb geetanjali mehra:
> Is it possible to move blob data type values out of table and keep it in
> separate page, keeping BLOB t
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
Is it possible to move blob data type values out of table and keep it in
separate page, keeping BLOB the part of the table.
Geetanjali Mehra
Oracle and MySQL DBA Corporate Trainer
On Mon, May 26, 2014 at 3:26 PM, Reindl Harald wrote:
>
> Am 26.05.2014 11:40, schrieb geetanjali mehra:
> > I w
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
signature.asc
Description: Ope
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.
Geetanjali Mehra
Oracle and MySQL DBA Corporate Trainer
Hello everyone,
We’re currently offering a 75% discount on all our (Windows based) products!
This includes test data generator, development and debugging tools, feel free
to take a look at http://www.upscene.com
Thank you for your attention.
With regards,
Martijn Tonies
Upscene Productions
