Re: Mysterious progress after recovery in MySQL Community Edition 5.1.34

2009-06-12 Thread Mike Spreitzer
ine (and I am not using replication) if necessary; is there a faster way to do that than uninstall and reinstall? Thanks, Mike Spreitzer Mike Spreitzer/Watson/i...@ibmus 06/12/09 12:57 PM To Michael Dykman cc mysql@lists.mysql.com Subject Re: Mysterious progress after recovery in MySQL

Re: Mysterious progress after recovery in MySQL Community Edition 5.1.34

2009-06-12 Thread Mike Spreitzer
otus Notes: Mike Spreitzer/Watson/IBM Office phone: +1-914-784-6424 (IBM T/L 863-) AOL Instant Messaging: M1k3Sprtzr Mike Spreitzer/Watson/i...@ibmus 06/12/09 11:50 AM To Michael Dykman cc mysql@lists.mysql.com Subject Re: Mysterious progress after recovery in MySQL Community Edition 5.1.34

Re: Mysterious progress after recovery in MySQL Community Edition 5.1.34

2009-06-12 Thread Mike Spreitzer
Watson/IBM Office phone: +1-914-784-6424 (IBM T/L 863-) AOL Instant Messaging: M1k3Sprtzr Michael Dykman 06/12/09 11:25 AM To Mike Spreitzer/Watson/i...@ibmus cc mysql@lists.mysql.com Subject Re: Mysterious progress after recovery in MySQL Community Edition 5.1.34 It looks to me like you h

Re: Mysterious progress after recovery in MySQL Community Edition 5.1.34

2009-06-12 Thread Michael Dykman
It looks to me like you had trouble shutting down because you were in the middle of a HUGE transaction.. having been killed, a rollback of nearly 10 million statement need be run. I would suggest that somewhere in your processing, you are holding one connection open a long time, doing a lot of wo

Mysterious progress after recovery in MySQL Community Edition 5.1.34

2009-06-12 Thread Mike Spreitzer
A colleague had to kill a MySQL server (on RedHat Enterprise Linux 5) because it had some problem shutting down. Later I launched it (with `/usr/share/mysql/mysql.server start`). In its err log I saw the recovery happen, apparently with a successful completion, and then the usual announcement

RE: Recovery in MySql

2003-01-30 Thread Inbal Ovadia
Mailinglist Subject: Re: Recovery in MySql On 1/29/03 5:13 AM, "Inbal Ovadia" <[EMAIL PROTECTED]> wrote: > Hi All, > I have MySql on Windows. > Today i had an electrical power interruption in the middle of working. > The database remain not consistent and i could

Re: Recovery in MySql

2003-01-29 Thread R. Hannes Niedner
On 1/29/03 5:13 AM, "Inbal Ovadia" <[EMAIL PROTECTED]> wrote: > Hi All, > I have MySql on Windows. > Today i had an electrical power interruption in the middle of working. > The database remain not consistent and i could not continue working with it. > > Is there any Recovery after crash mechanis

Re: Recovery in MySql

2003-01-29 Thread Andrey V. Ignatov
Hello Inbal, Wednesday, January 29, 2003, 4:13:24 PM, you wrote: IO> Hi All, IO> I have MySql on Windows. IO> Today i had an electrical power interruption in the middle of working. IO> The database remain not consistent and i could not continue working with it. IO> Is there any Recovery after cr

Recovery in MySql

2003-01-29 Thread Inbal Ovadia
Hi All, I have MySql on Windows. Today i had an electrical power interruption in the middle of working. The database remain not consistent and i could not continue working with it. Is there any Recovery after crash mechanism in mySql? Thanks, Inbal