mysql disk management

2002-02-12 Thread Magyari Istvan
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/

mysql disk management

2002-02-11 Thread Magyari Istvan
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/