Hi, An int datatype takes 4 bytes and a bigint 8 bytes. . Since there is an index created with bigint it will take an additional 8 bytes for the data and some more bytes for the pointer to the table rows. Thus a bare minimum of 20+ bytes is consumed corresponding to a row of data. A billion records will then need 20+GB of FREE disk space. The database may have many other overheads, for building indexes etc. You may also check the size of the operating system files for the table and index for the space consumed for 600M row. By dividing the total space by 600,000,000 will give you 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 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
