List:Internals« Previous MessageNext Message »
From:Hagen Höpfner Date:February 23 2006 2:10pm
Subject:Re: Packed Data in MyISAM
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sergei Golubchik wrote:
> Hi!
>
> On Feb 23, Hagen H?pfner wrote:
>> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
>>
>> Dear list,
>>
>> this time I have only a short question ... why are varchar
>> attributes packed but text attributes not?
>
> Because one may want a data type with space-stripping or without.
> But in 5.1 varchars are not packed either.
Interesting, but I believe that you did not changed the MYI-Structure.
Therefore, there should be some more not longer used entries starting
from 5.1 ;-) ... Perhaps and if you are interested, i'll compile a
list of things that might not longer be in use in 5.1. This might be
interesting for all  fellows outside that try to understand whats
going on in MyISAM ;-)

Hagen

- --
- ------------------------------------------------------------
Dr.-Ing. Hagen Höpfner | hoepfner@stripped | +49 7251 700 239
- ------------------------------------------------------------
         http://www.i-u.de/schools/hopfner/index.html

             International University in Germany
               School of Information Technology
                  Campus 3  D-76646 Bruchsal
- ------------------------------------------------------------
Information about the German textbook  on  "Mobile Databases
and   Information   Systems"  by   H. Höpfner, C. Türker and
B. König-Ries are available at http://www.dpunkt.de/.
- ------------------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (Darwin)
Comment: GnuPT 2.6.0 by EQUIPMENTE.DE
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFD/cJaataeEpWdQtYRAi2eAJsFDGmAJ/bh6GuqY4RdwB4zYU95GgCgi3VP
YhAOlPolQaFBh0X4RbwZwD0=
=gDCU
-----END PGP SIGNATURE-----

Thread
MYI ... Basedata ...Hagen Höpfner19 Dec
  • Re: MYI ... Basedata ...Sergei Golubchik19 Dec
    • Re: MYI ... Basedata ...Hagen Höpfner3 Feb
      • Re: MYI ... Basedata ...Sergei Golubchik7 Feb
    • Re: MYI ... Basedata ...Hagen Höpfner20 Feb
      • Re: MYI ... Basedata ...Sergei Golubchik20 Feb
        • Packed Data in MyISAMHagen Höpfner23 Feb
          • Re: Packed Data in MyISAMSergei Golubchik23 Feb
            • Re: Packed Data in MyISAMHagen Höpfner23 Feb
              • Re: Packed Data in MyISAMSergei Golubchik24 Feb