Re: How to View MySQL Temp Files and Temp Tables in Linux

2010-04-08 Thread Johan De Meersman
On Wed, Apr 7, 2010 at 11:45 PM, shamu...@gmail.com shamu...@gmail.comwrote: Below is my MySQL Server's status and configuration. But I can not see anything under /tmpfs/, it is showing empty to me. here is the result of ls -al drwxrwxrwx 2 mysql mysql60 Apr 7 17:43 tmpfs Could

How to View MySQL Temp Files and Temp Tables in Linux

2010-04-07 Thread shamu...@gmail.com
Below is my MySQL Server's status and configuration. But I can not see anything under /tmpfs/, it is showing empty to me. here is the result of ls -al drwxrwxrwx 2 mysql mysql60 Apr 7 17:43 tmpfs Could anyone tell me how to check the status of temp files and temp tables on disk? Thanks.

MySQL temp files?

2005-11-08 Thread Timothy Wu
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

Re: MySQL temp files?

2005-11-08 Thread Duncan Hill
On Tuesday 08 Nov 2005 08:42, Timothy Wu wrote: 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

Re: MySQL temp files?

2005-11-08 Thread Gleb Paharenko
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