RE: database Table Size Limitation - Arjen Lentz - com.mysql.lists.win32

6 messages in com.mysql.lists.win32RE: database Table Size Limitation

From	Sent On	Attachments
Peter Arnold	15 Jan 2002 02:27
Peter Arnold	15 Jan 2002 06:44
Jose Ostos	15 Jan 2002 08:48
Darren Martz	16 Jan 2002 09:45
Arjen Lentz	16 Jan 2002 17:57
Peter Arnold	17 Jan 2002 05:30

Subject:	RE: database Table Size Limitation
From:	Arjen Lentz (arj...@mysql.com)
Date:	01/16/2002 05:57:17 PM
List:	com.mysql.lists.win32

Hi Darren,

On Thu, 2002-01-17 at 03:46, Darren Martz wrote:

Internally Windows supports very large files with a 64 bit file position reference, but to natively support it would require changing MySQL source.

I'm afraid that is incorrect: no source changes are necessary. See http://www.mysql.com/doc/T/a/Table_size.html in the online manual.

Naturally, I'm assuming that a 3.23 or higher is used (3.22 had lower limits). For 3.23.x and 4.x the actual limit is operating system and file system dependent.

Within MySQL Server, the only thing you need to do is specify the AVG_ROW_LENGTH and MAX_ROWS parameters when creating your table; this adjusts the pointer size that the server uses in the table. You can also set these later with ALTER TABLE.

Regards, Arjen.