7 messages in com.mysql.lists.win32RE: Over 4GB DB on NT
FromSent OnAttachments
Horizon09 Apr 2003 16:43 
Public Folder: MySQL09 Apr 2003 17:11 
Gino, Antonio09 Apr 2003 18:47 
Brent Young09 Apr 2003 18:48 
Public Folder: MySQL09 Apr 2003 18:58 
Anto...@med.va.gov10 Apr 2003 10:47 
Public Folder: MySQL10 Apr 2003 11:16 
Subject:RE: Over 4GB DB on NT
From:Gino, Antonio (Anto@med.va.gov)
Date:04/09/2003 06:47:22 PM
List:com.mysql.lists.win32

That is TOTALLY INCORRECT! NTFS can handle partitions of any size, as long as they are NOT the primary partition (where NT is installed). Create a partition, also NTFS, that is not primary and you can make it as big as you want. Place the database in the non-system partition and you will have zero problems with size.

Can anyone give the basic tips to handle large DB on NT.

I read somewhere about the table needing to know it will be a big table in order to use the right pointer size ...

Make sure it's on a NTFS partition or you will not be able to exceed 4GB.