List:Internals« Previous MessageNext Message »
From:Stewart Smith Date:April 19 2006 3:44pm
Subject:Re: InnoDB / BDB / MyISAM - storing attribute values
View as plain text  
On Wed, 2006-04-19 at 09:33 +0200, Hagen Höpfner wrote:
> perhaps a stupid question but I need to know it ;-) The internals
> documentation describes how MyISAM stores attribute values physically
> (text encoding, date transformation, etc. ...). How is this done in
> InnoDB or BDB? I know that InnoDB uses it's own dataset format. Does the
> binary encoding of the attribute values differs too? And ... if not, is
> it equal for all MySQL storage engines?

As Serg has said, it differs.

The conversion routines are in the handlers for each storage engine -
sometimes in different ways. Have a look at what csv (ha_tina) does. NDB
(ha_ndbcluster) has a function that does it all IIRC.

Sometimes the conversion is a no-op.

Some engines can just use the internal row format (I think ARCHIVE does
this).
-- 
Stewart Smith, Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@stripped
Mobile: +61 4 3 8844 332

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html

Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Thread
InnoDB / BDB / MyISAM - storing attribute valuesHagen Höpfner19 Apr
  • Re: InnoDB / BDB / MyISAM - storing attribute valuesSergei Golubchik19 Apr
  • Re: InnoDB / BDB / MyISAM - storing attribute valuesStewart Smith19 Apr