We used to have a fair amount of data in InnoDB.
Had a few crashes from power failures at a crappy hosting provider.
Everytime the InnoDB engine seemed to detect the crashes and read up its
logfiles and recover.
I've never tried any "manual" InnoDB recovery / data extraction. Are there
methods?
Hi there,
I am not sure I understood your question correctly. What exactly is it that
you want to test ?
a) the recovery possibility in case of power down
b) the recovery possibility in case of client disconnection (network
interruption, timeout etc.)
c) Recovery possibilities in general access
Hi,
> Do you know how to test a crash and a rollback?
You mean a client app crashing on you?
How about disabling/unplugging the network?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
