MySQL maximums?

From: Date: Mon, 02 Apr 2001 13:13:58 +0000
Subject: MySQL maximums?
Groups: php.db 
Request: Send a blank email to php-db+get-8135@lists.php.net to get a copy of this message
What is ... 1) The maximum number of tables in a database? 2) The maximum number of rows and 3) (most importantly) the maximum size of a MySQL MyISAM table ? (3.23.35) 1. I can find no documentation on this; assuming its atleast 2 bytes; or 65536 tables; this value is if no real concern. 2. From what I can gather a key can be up to 500 bytes long (without using special directives, you can increase this to 1024 bytes...). Which means a ridiculous number of rows (2^500 ... ). Is that the true maximum of a row count? 3. Is this simply limited to the Operating System?? Eg; FAT16 is what? 512 MBs with 8kb sectors? FAT32 is 2^32 * 8kb (sectorsize) == 32 Terabytes?? (What about on Win98 as opposed to W2000? Is Win2000 a 64bit OS in this case?) NTFS? What about Redhat on a MIPs machine? (Cobalt RAQ2). Or are table sizes limited by other things?? Thanks, Siggy

« previous php.db (#8135) next »