Well, if i'm usin ext2 with a blocksize on 4 kb, then the largest file should be about 4 gb, right ?
-----Original Message----- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: 27. marts 2002 12:16 To: [EMAIL PROTECTED] Subject: Large datafiles Svend, Wednesday, March 27, 2002, 12:30:28 PM, you wrote: SEHJ> I'm running mysql 3.23.36 on a Red Hat 7.1 with the standard kernel. SEHJ> I have a /var partition (ext2) with 6.5 gb total space. SEHJ> One of the tables are almost running out of space, it is almost 4 gb. is it SEHJ> the filsystem that prevents files larger than 4 gb, or is it mysql that SEHJ> should be tweaked ? SEHJ> If i could use the last 2 gb on the partition, my problems would be solved SEHJ> for the next 4 months, any sugestions ? Do you use MyISAM tables? Maximum size of MyISAM table depends on your OS. By default MySQL tables have a maximum size of about 4G, but you can increase table size by editing AVG_ROW_LENGTH and MAX_ROWS when you CREATE or ALTER table. You can read more at: http://www.mysql.com/doc/T/a/Table_size.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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