Jonathan Villa wrote:
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?
for finding (and deleteing) biiig temp files check also /tmp; /var/tmp;
etc.
HTH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
