RE: creating big tables with over 2G size

[Kam Lung Ha]

Thanks for the info. I am running this on Linux. I don't think the RAID
options
will help.
Any ideas of sloving this 2G problems. ANy help is appreciated.

Thanks in advance.

Kam

-----Original Message-----
From: Jeremy D. Zawodny [mailto:jzawodn@stripped]
Sent: Wednesday, November 08, 2000 2:05 AM
To: Kam Lung Ha
Cc: mysql@stripped
Subject: Re: creating big tables with over 2G size


On Tue, Nov 07, 2000 at 05:47:52PM -0500, Kam Lung Ha wrote:
>
> I am using mysql version 3.23.21-beta. I have tried different
> options to create a table that can store over 2G of data. I use
> RAID_TYPE, RAID_CHUNKS and RAID_CHUNKSIZE in create table.  Nothing
> works. I even use the --with-raid option when starting mysql. But
> the option was rejected. The error from mysql is that it can not be
> recognized.

That's a *compile* time option, not run-time.

So, logically, you need to recompile with support for RAID tables.

Jeremy
--
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: [phone]    Fax: [phone]
Cell: [phone]