Hello.
Reading this could help a bit you: http://dev.mysql.com/doc/refman/5.0/en/temporary-files.html >Hi, > >While I was trying to index a field on an already existing table, my >partition became full. Checking into mysql database I realized the >repository (if it is so called?!) for the database files (frm, myd, and myi) >were located at /var/lib/mysql/diginorth/. I found three files started with >pound signs that I guessed were temporaries that were created while >indexing. I want to remove those files. And perhaps move the repository to >another partition. So I manually removed the files. However, not much disk >space was freed from the operations. I suspect what I removed were hard >symlinks, but I wasn't quite sure. Why wasn't my disk space freed? How would >I be able to free disk space? If it were symlinks where are the real files >located? > >Timothy > >usa:/var/lib/mysql/diginorth# ls -lh >total 14G >-rw-rw---- 1 mysql mysql 65 2005-10-20 16:51 db.opt >-rw-rw---- 1 mysql mysql 8.9K 2005-10-25 11:02 EST.frm >-rw-rw---- 1 mysql mysql 6.4G 2005-10-25 20:03 EST.MYD >-rw-rw---- 1 mysql mysql 155M 2005-11-08 11:29 EST.MYI >-rw-rw---- 1 mysql mysql 8.9K 2005-10-22 12:37 RefSeq.frm >-rw-rw---- 1 mysql mysql 135M 2005-10-23 14:46 RefSeq.MYD >-rw-rw---- 1 mysql mysql 1.4M 2005-10-24 13:36 RefSeq.MYI >-rw-rw---- 1 mysql mysql 8.7K 2005-10-27 12:48 SAGE.frm >-rw-rw---- 1 mysql mysql 110M 2005-10-27 12:49 SAGE.MYD >-rw-rw---- 1 mysql mysql 5.0K 2005-11-08 11:29 SAGE.MYI >-rw-rw---- 1 mysql mysql 8.9K 2005-11-08 11:44 #sql-777_5.frm >-rw-rw---- 1 mysql mysql 6.1G 2005-11-08 12:26 #sql-777_5.MYD >-rw-rw---- 1 mysql mysql 288M 2005-11-08 12:12 #sql-777_5.MYI > >usa:/var/lib/mysql/diginorth# df >Filesystem 1K-blocks Used Available Use% Mounted on >/dev/hda1 28834716 27369988 4 100% / >/dev/hda6 160848624 43564416 109113556 29% /home >/dev/hdd1 115377640 56761340 52755388 52% /data >tmpfs 1037944 0 1037944 0% /dev/shm Timothy Wu <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]