Re: Big Tables

["Roger Westin" <uki_1@xxxxxxxxxxx>]

Thanks Setve,
but right now I cant change the filesystem, so I need to go for the
with-raid option,
I read the manual and recompiled my MySQL, but I still cant get bigger
files than 2GB. Accordning to the manual it shall create sub directorys
named 00, 01, 02, etc
any idea?

/roger



> From: Steve Ruby <steve@xxxxxxxxxxxxxxxxx>
> To: Roger Westin <uki_1@xxxxxxxxxxx>
> CC: mysql@xxxxxxxxxxxxxxx
> Subject: Re: Big Tables
> Date: Fri, 09 Mar 2001 11:07:11 -0700
>
> Roger Westin wrote:
> >
> > Hi,
> > Have a problem with big tables,
> > Cant get them over 2GB
> > Using mysql 3.23.33
> > and ReadHat Linux 6.0 Kernel: 2.2.5
> >
> > Need to biuld a table atleast 70Gb so Anyone?
> >
>
> switch to a file system that supports very large files
>
> The problem should be with linux no mysql.
>
> there is an option to split tables to different
> files (see with-raid in the manual) but it won't
> split indexes, and if you have 70gig of data you
> probably have a very large index as well...
>
> ---------------------------------------------------------------------
> 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 <mysql-thread67806@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail 
> <mysql-unsubscribe-uki_1=hotmail.com@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


---------------------------------------------------------------------
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 <mysql-thread67845@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php