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
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
phone: +1-914-784-6424 (IBM T/L 863-)
AOL Instant Messaging: M1k3Sprtzr
Michael Dykman mdyk...@gmail.com
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
Office phone: +1-914-784-6424 (IBM T/L 863-)
AOL Instant Messaging: M1k3Sprtzr
Michael Dykman mdyk...@gmail.com
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
Mike Spreitzer/Watson/i...@ibmus
06/12/09 11:50 AM
To
Michael Dykman mdyk...@gmail.com
cc
mysql@lists.mysql.com
Subject
Re: Mysterious progress after recovery in MySQL Community Edition 5.1.34
Yes, when the shutdown was initiated there was a huge LOAD DATA in
progress. Is there some server