Posted by NC on 06/03/06 18:30

alfred wallace wrote:
>
> table size on mysql ( win XP ), is known as being at least 2 GO.

Not exactly. Generally speaking, a MyISAM table includes three files,
a data file, an index file, and a definition file. Definition file is
usually small, so we won't discuss it here. Now the data file and the
index file must be of a size manageable by the file system. A Windows
XP machine may have a FAT32 file system (maximum file size 4 Gb) or an
NTFS file system (maximum file size 4 Tb).

> but what i see in structure field of phpmyadmin is
>
> Type Espace
> Données(data) 1 008 Ko
> Index 351 232 Octets
> Total 1 351 Ko
>
> and a total of more than 2 100 Ko makes records crash ( deleted )
> with red warning in those fields.

What error message does MySQL give you?

> Does anybody know something about this.

Obviously the problem is not in the table size. It is possible that
the user under which MySQL server runs has a disk space quota that has
been exceeded.

It is also possible you have exceeded cardinality of the primary key or
a unique key. Let's say your primary key is defined as SMALLINT
UNSIGNED. This means that it can only hold values between zero and
65535. If you wanted to put more than 65535 records into the table,
MySQL won't accept it. Check your table definition.

Cheers,
NC

[Back to original message]