List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:November 16 2001 8:29pm
Subject:Re: shutdown still a problem on Darwin
View as plain text  
In the last episode (Nov 16), Erik Price said:
> --- Dan Nelson <dnelson@stripped> wrote:
> > As long as there are no active connections, killing mysql will not
> > affect the database.  If you kill mysql during an update, you risk
> > corrupting any indexes on the tables being modified.  If your
> > tables are BDB or InnoDB format, you should be able to kill mysql
> > at any time without damaging your tables.
> 
> What about the mysql database itself -- the grant tables?  I'm the
> only user right now (and my partner will join a bit later on), but I
> my project won't go "public" until it gets onto a more stable server,
> so I'm not worried about any connections being open, but won't the
> grant tables be accessed when I execute mysqladmin shutdown?  Oh...
> right, I'm not executing that.  Alright, that's good news!  Thanks!

Reads don't modify the tables anyway.  You only have to worry about
killing mysql during an update.

-- 
	Dan Nelson
	dnelson@stripped
Thread
shutdown still a problem on DarwinErik Price16 Nov
  • Re: shutdown still a problem on DarwinSinisa Milivojevic16 Nov
    • Re: shutdown still a problem on DarwinErik Price16 Nov
      • Re: shutdown still a problem on DarwinSinisa Milivojevic16 Nov
        • Re: shutdown still a problem on DarwinMichael Widenius19 Nov
      • Re: shutdown still a problem on DarwinDan Nelson16 Nov
        • Re: shutdown still a problem on DarwinErik Price16 Nov
          • Re: shutdown still a problem on DarwinDan Nelson16 Nov