At 5:19 +0200 9/1/02, David Lloyd wrote: >Paul et al, > >> At 18:59 -0400 8/31/02, qlarry wrote: >> >here a file size limit in my sql >> >> What? > >I think that loosely should translate as "Where is a file size limit in >MySQL" which I would then interpret as "Is there a file size limit in >MySQL". > >All MyISAM tables are stored on the local file system so it is dependant >on the file system and operating system you are running. Or to put it >another way, your MyISAM table (MySQL's default type) are stored as >files, and it is your operating system that limits the file size and not >MySQL. > >As for other types such as BDB and InnoDB I don't know the answer.
ISAM: minimum of 4GB per file (MyISAM internal limit) or OS file size limit. MyISAM: same, except that by using AVE_ROW_LENGTH and MAX_ROWS you can bump the MyISAM internal limit to approx 8 terabytes. BDB: minimum of at least 2 TB (MyISAM internal limit) or OS file size limit. InnoDB: depends on size of InnoDB tablespace. By default, max tablespace size is 4 billion pages x 16KB per page. But all InnoDB tables compete for space inside this tablespace. > >I hope this helps. > >DSL >-- >Say you'll share with me one love, one lifetime > Lead me, save me from my solitude. >Say you'll want me with you, here beside you > Anywhere you go let me go too... (Webber/Hart/Black) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php