Where is my 2G? - MC

[Andrew Mason]

On Fri, 13 Apr 2007 11:47:10 pm Michael Cohen wrote:
> On Fri, Apr 13, 2007 at 11:20:30PM +0930, Mark Newton wrote:
> > There are millions of Linux systems installed all over the world.
> > At least one of them would suffer from a full filesystem every single
> > day of the week.  If filling up filesystems damages them so badly that
> > you need fsck to recover them, why do you think your story is the -first-
> > we've heard of this?  Why aren't we hearing about this every time someone
>
> Hehehe this thread is quite funny. I must say that I was impressed that
> many programs are actually accustumed to filling up the filesystem and
> handle it quite gracefully. We have a mysql db which we were tryng to load
> data onto - it has lots (million and millions of rows) inserted into it and
> was going to take a while... Came back the next day and mysql has stopped,
> in fact the last insert query was just blocked and didnt complete yet (for
> probably about 6 hours or so). Turned out the fs was full. Surprisingly (or
> perhaps not too surprisingly) we just deleted some files on the fs and
> mysql came back to life and just went on from where it left off... thats my
> definition of graceful...
>
> :-) I kind of expected the query to be aborted but mysql is smart enough to
Not very smart in my opinion. 

1) it didn't tell you there was a problem so you couldn't fix it.
2) What it should have done, is rolled back the transactions to it's original 
state, then told you it couldn't do it because it couldn't write to the disk.


Also, just in case you don't already know, if a table has millions and 
millions of rows that need inserting, make sure you add the indexes last as 
it can save hours on the insertion of large tables :) 

Andrew 


>
> just wait it out...
>
> Sorry for the off topicness...
> Michael.