Re: MySQL v8 - MYISAM Pack Information

[Frank Peacock]

Hello,

I have performed further tests and still the INFORMATION_SCHEMA information about the packed MYISAM table has not updated the lengths of the average_row and data on MySQL v8.

I have tried with external_locking both on and off.
I have tried flushing tables both using mysqladmin and within mysql_client at different stages of the packing and index updating.
Finally I also had to do a 'check table' on the packed table to finally get the row format to update from "Fixed" to "Compressed".

All the above was unnecessary in v5.7. So I presume v8 has changed a great deal.

I have also checked the packed table's sdi file. The following options seem incorrect:
The option "stats_auto_recalc=0" may be of significance. I thought that this was only for innodb files.
The option "avg_row_length=0" also be of significance.
The option "pack_record=0" seems incorrect.
The only option which I set and which is correct is "max_rows=11959552".

I would be extremely grateful for any assistance,

Thanks,

Frank