tabase files got
> before the failure happened etc.
>
> Magyari Istvan wrote:
> > Hi,
> >
> > I have been trying to build a 1 billion row database, in mysql version
> > 3.23.47, under Suse 7.3, but failed a several times, i reached around
> > 600.000.000
Interesting subject ;-)
Can you provide some more information; Like exactly what failed, any
errors you received, if it crashed, how big the database files got
before the failure happened etc.
Magyari Istvan wrote:
>
>
> Hi,
>
> I have been trying to build a 1 billion r
space needed
for a single
row of data.
What is the free disk space available before inserting the data? How do you
commit the data? What is the table type?
Anvar.
At 10:05 AM 07/02/2002 +0200, you wrote:
>Hi,
>I have been trying to build a 1 billion row database, in mysql version
>3.23.
space needed
for a single
row of data.
What is the free disk space available before inserting the data? How do you
commit the data? What is the table type?
Anvar.
At 10:05 AM 07/02/2002 +0200, you wrote:
>Hi,
>I have been trying to build a 1 billion row database, in mysql version
>3.23.
tabase files got
> before the failure happened etc.
>
> Magyari Istvan wrote:
> > Hi,
> >
> > I have been trying to build a 1 billion row database, in mysql version
> > 3.23.47, under Suse 7.3, but failed a several times, i reached around
> > 600.000.000
Interesting subject ;-)
Can you provide some more information; Like exactly what failed, any
errors you received, if it crashed, how big the database files got
before the failure happened etc.
Magyari Istvan wrote:
>
>
> Hi,
>
> I have been trying to build a 1 billion r
Hi,
I have been trying to build a 1 billion row database, in mysql version
3.23.47, under Suse 7.3, but failed a several times, i reached around
600.000.000 rows...
The table has an int(10) unsigned and a bigint(20) field, indexed by the
bigint(20) field.
The hardisk is 26GB SCSI, the
