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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. --------------------------------------------------------------------- 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
