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 2.1GB (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...
in /usr/local/mysql/data there is one dir named the same as the db they are working on, then there is this other file called ibdata1 which is 2.1G in size. I take a look at the first few lines and all I get is garbled data, as if it were a binary file or something. any ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]