Hi!
> >>>-----------------------------------------------------------
> >>>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?
Cannot repeat. It's not 0 in my tests.
Didn't you forget ANALYZE TABLE ?
> - -----------------------------------------------------------
>
> 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?
Looks like it.
But don't know more than you here, all I can say is - they are
apparently not used now, and they were never used since we started use
BitKeeper.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Kerpen, Germany
<___/ www.mysql.com
