mysql disk management

Hi, Can you help on this? I'm trying to index a table with bigint(20), 8 byte field (under linux), there are now 650.000.000 rows and takes 8,5Gb space. Free space is 17Gb, twice and stil cant index it couse runs out of space??? aaa@cab1:~/mysql_tests> sudo ls -l /var/lib/mysql/test2docfp/

performance mysql 4.00alpha vs mysql 3.23.47

structure etc... Is that so? 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

mysql disk management

Hi, Can you help on this? I'm trying to index a table with bigint(20), 8 byte field (under linux), there are now 650.000.000 rows and takes 8,5Gb space. Free space is 17Gb, twice and stil cant index it couse runs out of space??? aaa@cab1:~/mysql_tests> sudo ls -l /var/lib/mysql/test2docfp/

1 billion row

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 I