List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:November 19 2001 3:11am
Subject:Re: shutdown still a problem on Darwin
View as plain text  
Hi!

>>>>> "Sinisa" == Sinisa Milivojevic <sinisa@stripped> writes:

Sinisa> Erik Price writes:
>> Sinisa, everyone,
>> 
>> That's great news!  I'm excited to hear that.  Which version would that
>> be... 4.0?  Or perhaps another 3.x version?
>> 
>> In the meantime, my boss is going to wonder why I'm not populating a
>> database for him.  He will make me use Access if I don't get cracking,
>> so... do you know of a working version of MySQL for Darwin 1.4.1 ?
>> 
>> Alternatively, I am open to a workaround until the working version is
>> released.  I can actually use MySQL (as far as I know), it's just the
>> "shutdown" that hangs.  I have to use "kill -9" in order to kill the
>> daemon.  This makes me worry about my data, since this command has the
>> potential to cause corruption.  Is there some way that I can preserve
>> the data, or protect it from corruption, so that at the end of the day
>> when I shut down my laptop I can use "kill -9" without fear of damaging
>> the contents?

You can do the following unilt 3.23.45 is released (probably by the
end of this week).

Make a short perl program that executes
'FLUSH TABLES WITH READ LOCK'

followed by a kill -9 on the mysqld process.

If you know that no client is connected to mysqld, you can just do:

mysqladmin flush-tables

and then issue the kill -9

<cut>

>> PS: do you advise that I beta-test the upcoming MySQL version?  I would
>> be open to this idea, especially if it fixes my problem, but I am
>> working in a production environment and so would be best served with as
>> stable a release as is available.

We run a lot of test on each MySQL release, and even alpha versions
are usually 'reasonable stable';  Even if many people are already using
4.0 in a production environment we encourage you to test it throughly
in your setup before converting to use this!

Regards,
Monty
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