RE: "The table 'mytable' is full" - Adam Clauss - com.mysql.lists.win32

5 messages in com.mysql.lists.win32RE: "The table 'mytable' is full"

From	Sent On	Attachments
Adam Clauss	28 Sep 2004 14:23
Petr Vileta	28 Sep 2004 14:54
Januski, Ken	28 Sep 2004 15:09
Adam Clauss	28 Sep 2004 15:33
Januski, Ken	28 Sep 2004 15:35

Subject:	RE: "The table 'mytable' is full"
From:	Adam Clauss (caba...@houston.rr.com)
Date:	09/28/2004 03:33:37 PM
List:	com.mysql.lists.win32

Doh... I searched, but apparently not hard enough. For reference, the problem was solved by the fourth bullet there about myisam_data_pointer_size. Was able to fix it by running the statement: ALTER TABLE tbl_name MAX_ROWS=1000000000

Thanks again!

http://dev.mysql.com/doc/mysql/en/Full_table.html

-----Original Message----- From: Adam Clauss [mailto:caba...@houston.rr.com] Sent: Tuesday, September 28, 2004 5:24 PM To: win...@lists.mysql.com Subject: "The table 'mytable' is full"

I am writing an application which creates a very large number of rows in a table. I have begun receiving the following error: "The table 'mytable' is full" The filesize of the myd file is 3.99 GB (4,294,967,284 bytes) (or 4.0GB on disk).

Now, my understanding was that the table size was only limited to the maximum filesize allowed by the OS (I'm using MySQL 4.0). But this is an NTFS partition on Windows XP - 4GB shouldn't be a problem. In fact I know it isn't as I have larger files (not mysql) located on the same drive (on the order of 7-8GB). Any ideas on what I need to do?