Tables exceeding 2gb
Hi, I have a Linux machine (Linux cartman 2.4.2-2smp #1 SMP Sun Apr 8 20:21:34 EDT 2001 i686 unknown) that is running MySQL 3.23.38-log and now I have a table that is getting VERY near to the ext2 filesystem limitation of 2gb. Exact size of the table is: 2039867196 :) So my question is. What happens? Does mysql write into another file and automatically merge them on the fly or does the table stop or what? Also what suggestions do you have concerning this matter? regards, Gudmundur
Re: Tables exceeding 2gb
Guðmundur Ólafsson [EMAIL PROTECTED] writes: Hi, I have a Linux machine (Linux cartman 2.4.2-2smp #1 SMP Sun Apr 8 20:21:34 EDT 2001 i686 unknown) that is running MySQL 3.23.38-log and now I have a table that is getting VERY near to the ext2 filesystem limitation of 2gb. Ext2 doesn't have a 2 GB limit. You seem to be running Red Hat Linux 7.1, and both kernel and C library support large files on this system. For more information, I recommend a look at http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html -- Trond Eivind Glomsrød Red Hat, Inc. - 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: Tables exceeding 2gb
(sql, to fool lame filter) ryc [EMAIL PROTECTED] writes: The OS may not have a 2GB limit, however the table MAY. If you do a myisamchk on the table it will tell you if you are running out of space in the table. If you are.. you need do something like alter table tablename max_rows=1000.. (its in the manual) Also, the package needs to be compiled on a system with LFS. This is detected at compile time, not at runtime. -- Trond Eivind Glomsrød Red Hat, Inc. - 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: Tables exceeding 2gb
Yee Chuan Loh [EMAIL PROTECTED] writes: The document at http://www.mysql.com/doc/T/a/Table_size.html seems to suggest that the reason why there's a limit to the table size is because of the number of bytes used by the file system to store offsets, so its more or less file system dependant (pls correct me if i'm wrong). You are - it's the bits used by kernel (through glibc) which are the important ones, ext2 doesn't have problems in that area. It also wrote that on Linux 2.2, the maximum size of a table on ext2 is 2GB, which can be increased if using LFS. But you're running 2.4.2-2 (which looks like Red Hat Linux 7.1, which also has a LFS-enabled glibc). Are you saying that we could compile the mysql package on a LFS partition, No, on a LFS-capable system. LFS is not a special property of the ext2 partition (if you're using ReiserFS, it's a little different - v2 doesn't support large files, v3 does). -- Trond Eivind Glomsrød Red Hat, Inc. - 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