-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Dear list members,
it's me again and I am looking for enlightenment. After a short break
I wanna now continue my tries to understand MYI-files ... Some month
ago we have already discusses the following:
>>>---------------------------------------------------------------------
>>>state->rec_per_key_parts 4 00 00 00 00 (key_parts = 3, so
>>> 00 00 00 00 rec_per_key_parts
>>> 00 00 00 00 occurs 3 times)
>>
>>Ok, this is an array, with number of elements equal to the total
>>number of keyparts of all indexes. For the table
>>
>... again, I tried out this ... might it be true, that
>rec_per_key_parts-entries are created but not calculated for keyparts
>coming from fulltext-indexes?
The answer was: "They are calculated - as I do remember a couple of
bugs in these
calculations that were fixed :) ..."
Now I changed to MySQL 5.0.8 and tried it again, with the same result.
For the key parts the value stays 00000000. Any ideas?
- ---------------------------------------------------------------------
Now let me continue with the base-data part of MYI.
mi_rowstore(ptr,base->records); ptr +=8;
mi_rowstore(ptr,base->reloc); ptr +=8;
I have got no idea what this values encode/mean? As far as I can see,
these values are read and written but not changed. Are they really needed?
All the best,
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 Thunderbird - http://enigmail.mozdev.org
iD8DBQFD419jataeEpWdQtYRAqsmAJ4z4+RAOePYw5Bd8xJPURkeK/ffNQCfYEka
CH8gv16n8G6GDINUOdYMgm0=
=U6Ny
-----END PGP SIGNATURE-----
