Check that your file size limit on your machine is more than the usual 4GB. I have a 23 million row database, and it translates into 3GB data file, 3GB index file. 1 billion records would never fit. My record length is about 300 bytes.
If you need more than a 4GB data file, you should check out different versions of the OS, I know some have a much bigger limit. steve On Thursday 07 February 2002 09:10, Colin Faber wrote: > 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 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 computer is a dual Pentium III with 1GHz, > > with 2GB memory > > > > I'd like to have your opinion about what should I be carefull at the > > table creation or mysqld settings, and how fast will be the queries in > > this 1 billion row and if its worth to make all in 1 table. > > > > Thank you, > > Magyari Istvan > > > > --------------------------------------------------------------------- > > 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 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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