I'm administering a Red Hat machine which is used soley for MySQL. The person working with the db has more than 15 million records in various tables...they were trying to run some queries to create one table from these many tables. When this was happening, they ran out of disk space. They had about 4GB free prior to running the queries... but are now down to 1.3GB (after I freed up some disk space, they were at 0) and no new table. Are there temp files created when running queries...I have restarted mysql several times, looked in /usr/local/mysql/data but nothing looks odd...I even tried restarting the machine...
I also tried a find / -size +5000 but nothing interesting is returned... any ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]