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 |
+---------------------------------------------------------------------+
