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 row database, in mysql
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 rows...
The table has an int(10) unsigned and a bigint(20) field
the 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.47, under Suse
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 rows...
The table has an int(10) unsigned and a bigint(20) field
the 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.47, under Suse
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
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 row database, in mysql