Re: Size Limitations
At 09:49 AM 1/30/2002 -0500, Hashim Ismail wrote: Is there a database size limitation with MySQl in the Windows NT and Windows 2000 enviroment? Like some databases have size limitation of 2GB. Yes. Read the manual. In a Windows environment, table sizes are limited to 2 gigabytes if memory serves, it is all in the manual, though. You can, of course, have more than one table in your database. - 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
RE: Size Limitations
The manual doesn't specify the Windows limit - only the Linux value of 2 gb. -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 9:57 AM To: Hashim Ismail; [EMAIL PROTECTED] Subject: Re: Size Limitations At 09:49 AM 1/30/2002 -0500, Hashim Ismail wrote: Is there a database size limitation with MySQl in the Windows NT and Windows 2000 enviroment? Like some databases have size limitation of 2GB. Yes. Read the manual. In a Windows environment, table sizes are limited to 2 gigabytes if memory serves, it is all in the manual, though. You can, of course, have more than one table in your database. - 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
RE: Size Limitations
The Linux version no longer has 2 GB limit. It is now whatever your disk capacity is. -Original Message- From: Steve Kramer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 11:34 AM To: Christopher Thompson Cc: MySQL Subject: RE: Size Limitations The manual doesn't specify the Windows limit - only the Linux value of 2 gb. -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 9:57 AM To: Hashim Ismail; [EMAIL PROTECTED] Subject: Re: Size Limitations At 09:49 AM 1/30/2002 -0500, Hashim Ismail wrote: Is there a database size limitation with MySQl in the Windows NT and Windows 2000 enviroment? Like some databases have size limitation of 2GB. Yes. Read the manual. In a Windows environment, table sizes are limited to 2 gigabytes if memory serves, it is all in the manual, though. You can, of course, have more than one table in your database. - 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 - 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
RE: Size Limitations
On Wed, 30 Jan 2002, Rick Emery wrote: The Linux version no longer has 2 GB limit. It is now whatever your disk capacity is. The no longer, however, is a function of later Linux kernels and filesystems. Linux 2.2 kernels with the ext2 filesystem (probably still the most common setup) have a 2GB file size limitation, which is the cause of the MySQL table size limitation. MyISAM tables, at least on 3.23, have a 4GB limitation unless you specifially configure it otherwise, even if the OS allows larger files. Given all of the possible combinations, if you're going to be pushing the limits of table sizes, it's best to simply test and find out what your particular config will allow you do to. james montebello - 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