Re: Can anyone help me with the SHOW TABLE STATUS OUTPUT
Posted by:
Rick James
Date: November 29, 2015 11:52PM
InnoDB is creates tables in 16KB blocks. You currently have 1 block. It computes (or estimates) the number or records. 2 in this case. Then it divides those two to bet 8KB.
Add a 3rd row to see what I mean.
Neither Num_rows nor Avg_row_length can be trusted.
Subject
Views
Written By
Posted
1234
November 28, 2015 09:28PM
Re: Can anyone help me with the SHOW TABLE STATUS OUTPUT
774
November 29, 2015 11:52PM
728
November 30, 2015 01:46AM
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.