Repair a MySQL InnoDB database table corrupted by a power outage = :related: Related Topics :r: I have a linux server built from a standard dell workstation. 1 500g sata II drive, core 2 duo, 1g ram. It is running Ubuntu server 8.04 with mysql (InnoDB tables), php, apache, and Zabbix. The primary role of this server is to monitor our other production servers using an open source monitoring application called Zabbix. We had a large electrical/tornado storm one day and power went out to the zabbi...

InnoDB provides MySQL with a transaction-safe (ACID compliant) storage engine that has commit, rollback, and crash recovery capabilities. However, it cannot do so if the underlying operating system or hardware does not work as advertised. Many operating systems or disk subsystems may delay or reorder write operations to improve performance. On some operating systems, the very system call that should wait until all unwritten data for a file has been flushed - fsync() - might actually return befo...