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/ total 8260031 -rw-rw---- 1 mysql daemon 8450000000 Feb 11 18:34 docfp.MYD -rw-rw---- 1 mysql daemon 1024 Feb 11 18:34 docfp.MYI -rw-rw---- 1 mysql daemon 8594 Feb 10 01:43 docfp.frm aaa@cab1:~/mysql_tests> df Filesystem 1k-blocks Used Available Use% Mounted on /dev/vol1/data 26213596 9254160 16959436 36% /cdb1 when i give 'create index fp_idx on docfp (fingerprint)' mysql makes temp files like this with #-s -rw-rw---- 1 mysql daemon 8450000000 Feb 11 18:58 #sql-18c5_4b.MYD -rw-rw---- 1 mysql daemon 1024 Feb 11 18:40 #sql-18c5_4b.MYI -rw-rw---- 1 mysql daemon 8594 Feb 11 18:40 #sql-18c5_4b.frm -rw-rw---- 1 mysql daemon 8450000000 Feb 11 18:34 docfp.MYD -rw-rw---- 1 mysql daemon 1024 Feb 11 18:34 docfp.MYI -rw-rw---- 1 mysql daemon 8594 Feb 10 01:43 docfp.frm after this consumes all 8,5Gb freespace left after this operation and stops with error message cant create temporary files.... mysql tmp directory is set to this mounpoint, i dont have space elsewhere .... Why needs so much space for index????? There is twice more space then the database and i know that the index file takes about the same space as this database..... --------------------------------------------------------------------- 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
