Re: [CentOS] MySQL/file system question

2012-02-13 Thread Adam Tauno Williams
On Mon, 2012-02-13 at 18:59 -0500, Boris Epstein wrote: > Here we go: > [root@gala ~]# ls -l /proc/18702/fd > total 0 ... > lrwx-- 1 root root 64 Feb 13 18:58 7 -> /home/mysql/tmp/ibE0DGCO > (deleted) > lrwx-- 1 root root 64 Feb 13 18:58 8 -> > /home/mysql/mysql_data/ib_logfile0 > lrwx-

Re: [CentOS] MySQL/file system question

2012-02-13 Thread Boris Epstein
On Mon, Feb 13, 2012 at 6:53 PM, Ljubomir Ljubojevic wrote: > On 02/13/2012 11:31 PM, Boris Epstein wrote: > >> > > In fact, I did look in /proc/{pid#}/fd and found the file names, thanks! > > Coud quite figure out the size of those invisible files - but no matter, > > hopefully I've got enough ro

Re: [CentOS] MySQL/file system question

2012-02-13 Thread Ljubomir Ljubojevic
On 02/13/2012 11:31 PM, Boris Epstein wrote: >> > In fact, I did look in /proc/{pid#}/fd and found the file names, thanks! > Coud quite figure out the size of those invisible files - but no matter, > hopefully I've got enough room. > ls -l /proc/{pid#}/fd -- Ljubomir Ljubojevic (Love is in the

Re: [CentOS] MySQL/file system question

2012-02-13 Thread Les Mikesell
On Mon, Feb 13, 2012 at 4:06 PM, Boris Epstein wrote: > > > > I haven't thought of it this way. In fact it matches with this description: > > http://dev.mysql.com/doc/refman/5.1/en/temporary-files.html > > I can kind of see the advantages; the disadvantages, of course, are that a > major transact

Re: [CentOS] MySQL/file system question

2012-02-13 Thread Boris Epstein
> > > > If the process is stopped the transaction cannot be resumed for a myriad > reasons; loss of the temporary file is a trivial concern. > > -- > System & Network Administrator [ LPI & NCLA ] > > OpenGroupware Developer > Adam

Re: [CentOS] MySQL/file system question

2012-02-13 Thread Adam Tauno Williams
On Mon, 2012-02-13 at 17:06 -0500, Boris Epstein wrote: > On Mon, Feb 13, 2012 at 4:58 PM, Adam Tauno Williams > wrote: > > On Mon, 2012-02-13 at 16:45 -0500, Boris Epstein wrote: > > > Hello listmates, > > > I got a rather strange situation that I can't quite make sense of. OK, > > I've > > > got

Re: [CentOS] MySQL/file system question

2012-02-13 Thread Boris Epstein
> > > > Easy. It is using temporary files the *correct* way. > > 1. Open file > 2. Unlink file > 3. Use file > 4. Close file > > This means (a) even if the process abends the resources allocated to the > file are released and (b) an external process can't see [or modify] the > temporary file. > >

Re: [CentOS] MySQL/file system question

2012-02-13 Thread Boris Epstein
On Mon, Feb 13, 2012 at 4:58 PM, Adam Tauno Williams wrote: > On Mon, 2012-02-13 at 16:45 -0500, Boris Epstein wrote: > > Hello listmates, > > I got a rather strange situation that I can't quite make sense of. OK, > I've > > got a very large data file to sort (hundreds of millions of lines) and I

Re: [CentOS] MySQL/file system question

2012-02-13 Thread Adam Tauno Williams
On Mon, 2012-02-13 at 16:45 -0500, Boris Epstein wrote: > Hello listmates, > I got a rather strange situation that I can't quite make sense of. OK, I've > got a very large data file to sort (hundreds of millions of lines) and I > decided to use MySQL for the purpose. I inserted the stuff into a tab