MySQL Forums
Forum List  »  Archive Storage Engine

Advanced Search
New Topic

What does Avg_row_length mean on an ARCHIVE engine table?
Posted by: Nick Sharp
Date: February 19, 2008 11:04PM

I have a MEMORY engine table that has fixed fields. SHOW TABLE STATUS reports Avg_row_length = 44

I also keep an ARCHIVE engine copy of the above table's rows, and SHOW TABLE STATUS of that reports Avg_row_length = 4140 (yes just over four thousand) yet Data_length/Rows=~11

I am very happy with the compression of about 75% but most puzzled by 4140.

MySQL community rhel5 edition 5.1.22

Any ideas please?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
What does Avg_row_length mean on an ARCHIVE engine table?
14201
Nick Sharp
February 19, 2008 11:04PM
Re: What does Avg_row_length mean on an ARCHIVE engine table?
6835
Brian Aker
February 19, 2008 11:59PM
Re: What does Avg_row_length mean on an ARCHIVE engine table?
10212
Roel Van de Paar
April 01, 2009 06:12PM


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.