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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
