List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:March 17 1999 12:34am
Subject:table size
View as plain text  
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   |
+---------------------------------------------------------------------+
Thread
table sizeBrett Error16 Mar
  • table sizesinisa17 Mar
    • Re: table sizeDax Kelson30 Mar
      • Re: table sizeRoman D. Sinyuk31 Mar