MySQL Forums
Forum List  »  MyISAM

Re: MySQL v8 - MYISAM Pack Information
Posted by: Frank Peacock
Date: September 02, 2020 02:30AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
311
September 01, 2020 08:04AM
Re: MySQL v8 - MYISAM Pack Information
155
September 02, 2020 02:30AM
157
September 03, 2020 02:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.