From: <sinisa
Date: March 17 1999 12:34am
Subject: table size
List-Archive: http://lists.mysql.com/mysql/365
Message-Id: <14062.63637.275707.525693@monster.local.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Brett Error writes:
 > I have not been able to find this information in the manual.  How large of
 > tables can MySQL handle?  Linux puts the limit on file size at 2 GB (yes
 > there are work around for this, but I haven't seen any that aren't ugly
 > hacks).  Can MySQL work around this?  For example, PostgreSQL automatically
 > creates additional files when the table size nears 2GB.
 > 
 > Just curious if MySQL will take care of very large tables, or if I need to
 > make sure a table never exceeds the OS limit.
 > 
 > Thanks much!
 > 
 > Brett
 > 
 > 

Hi!

Yes, on Linux 2Gb is a present limit.

Future improvements  (3.23) will include workarounds, especielly with
Reiser FS, which is a replacement for ext2.

Sinisa

+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___        ==  mysql@stripped        |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|        Sinisa Milivojevic      |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|        mailto:sinisa@stripped |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|        Belgrade                |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____   Serbia                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+