RAID tables works fine for me.
I don't know which OS you are running, i got it to work with a
linux box like this:
1. Upgrade to the 2.4 linux kernel(Or patch an older kernel with the LFS
patch)
2. Recompile mysql 3.23 with the --with-raid configure option (the
precompiled binaries doesn't seem to have this feature compiled in).
3. Create a RAID table like the manual describes.
Sincerely,
Christian.
btw: I am using ext2, but it should work the same with reiserfs.
-----Original Message-----
From: funky gao [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 12:41 PM
To: Firdaus Mah
Cc: Jerome Abela; [EMAIL PROTECTED]
Subject: Re: raid tables doesnt seem to split files.
Hi Firdaus!
On Thu, 12 Oct 2000, Firdaus Mah wrote:
> Hi Jerome,
>
> Heh... I'm already doomed. I'ved just inserted 32 million records and its
> stopped at 2GB even using on reiserfs.
> I'ved not checked the detail or experience in Postgress development. Does
it
> do stripping as well ie breaking up tables and index file.
It is not reiserfs which is limiting you to 2GB (reiserfs is unsigned and
should limit you to 4GB), however the VFS layer is only signed so it will
not communicate the extra bit to reiserfs so that it will access >2GB.
I suspect that if you were to apply the LFS patches it will start working,
but I've never done it on a reiserfs partition.
>
> My conclusion is that until this moment, MySQL is suitable for small to
medium
> databases.
Not true, I have MySQL running on a Alpha and have none of these limitations
=)
-Myron
>
> firdaus
>
> Jerome Abela wrote:
>
> > On Wed, Oct 11, 2000 at 12:51:50PM +0800, Firdaus Mah wrote:
> > > this is how i'ved created
> > > create table test (field char(70) not null primary key)
RAID_TYPE=STRIPED
> > > RAID_CHUNKS=1024 RAID_CHUNKSIZE=1024;
> >
> > This only works if mysqld was compiled with the --with-raid option.
> > You can check this by grepping 'CONFIGURE_LINE=' from mysqlbug script.
> > Otherwise, the RAID option to CREATE is silently ignored.
> >
> > Note that only the data file (MYD) is stripped. If your index becomes
> > too big, you are doomed.
> >
> > Jerome.
>
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/documentation/manual.php" before
> posting. To request this thread, e-mail [EMAIL PROTECTED]
>
> To unsubscribe, send a message to:
> <[EMAIL PROTECTED]>
>
> If you have a broken mail client that cannot send a message to
> the above address (Microsoft Outlook), you can use:
> http://lists.mysql.com/php/unsubscribe.php
>
>>>> VIGILANTe.com NOTICE - AUTOMATICALLY INSERTED <<<<
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited.
Any opinions expressed in this email are those of the individual and not
necessarily the Company.
If you receive this transmission in error, please email to
[EMAIL PROTECTED], including a copy of this message. Please then
delete this email and destroy any copies of it.
>>>>>>>>>>>>>>>>>>>>>>>>>> DISCLAIMER END <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
---------------------------------------------------------------------
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
