Bug #7141 MySQL Amdi show wrong table data size

• Submitted: 9 Dec 2004 18:12
• Modified: 7 Oct 2005 8:58
• Reporter: Andrew Sitnikov
• Status: Duplicate
• Category: MySQL Administrator
• Severity: S3 (Non-critical)
• OS: Windows (Windows XP)
• Assigned to: Mike Lischke
• CPU Architecture: Any

[9 Dec 2004 18:12] Andrew Sitnikov

Description:
See screenshot for detail
http://si.infonet.ee/tmp/mysql-admin-bug1.png

show table status like 'letters_text';       
+--------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+---------------------+---------+
| Name         | Type   | Row_format | Rows     | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time          | Create_options      | Comment |
+--------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+---------------------+---------+
| letters_text | MyISAM | Dynamic    | 32313681 |            206 |  6664236240 | 281474976710655 |    329020416 |         0 |       77682422 | 2004-01-06 23:56:31 | 2004-12-09 20:09:29 | 2004-12-06 05:03:41 | max_rows=4294967295 |         |
+--------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+---------------------+---------+

How to repeat:
Run program ;)

[9 Dec 2004 18:12] Andrew Sitnikov

screenshot

Attachment: mysql-admin-bug1.png (image/x-png, text), 123.28 KiB.

[9 Dec 2004 18:45] MySQL Verification Team

I wasn't able to repeat and probably this happens with specific columns
or create table definition. Can you provide the table schema where you
got the wrong data size ?.

Thanks in advance.

[9 Dec 2004 18:54] Andrew Sitnikov

CREATE TABLE `letters_text` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `subject` varchar(250) default NULL,
  `text` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM MAX_ROWS=4294967295

[20 Dec 2004 7:40] Andrew Sitnikov

MySQL administrator version 1.0.18 + mysql 4.1.8 also have this problem

[20 Dec 2004 7:43] Andrew Sitnikov

screenshot

Attachment: mysql-admin-bug2.png (image/x-png, text), 76.45 KiB.

[23 Dec 2004 14:31] MySQL Verification Team

MA shows wrong table data size if .MYD is bigger than 4G.

[7 Oct 2005 8:58] Mike Lischke

This is a duplicate of http://bugs.mysql.com/bug.php?id=8960. Actually the other is newer but I did not see this one earlier.