… – when page in clustered key index is corrupted. It is worse compared to having data corrupted in secondary indexes, in which case simple… Duplicates: 0 Warnings: 0 Now you got all your data in MyISAM table so all you have to do is to drop… think will will scan the table until first corrupted row and get result in MyISAM table ? Unfortunately test2 ended up to be…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… or MySQL bugs but corruption may happen and go for long unnoticed with MyISAM storage engine. This hidden corruption may later cause crashes wrong query results and further data corruption. Partial updates. MyISAM is does…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… are still some edge cases such as modifying meta data stored in MyISAM tables which can get master out of sync with… have master data lost, such as you have RAID or disk failure. Though it also can be things like Innodb corruption or…) – for example you may have master or relay binary log corruption. Master or Slave running out of space, Slave crashing (and…
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
…. If other MySQL node crashes it leaves table in potentially corrupted state which you need to check and repair before you… I remember MySQL simply was not repairing corrupted tables in this configuration even if myisam_repair is set. Space Saving ? As I mentioned replication can be better idea but may be the problem is your data…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… NOT have the time for a REPAIR TABLE on your MyISAM‘s corrupted table. You say you need to prepare for a…’ve met a DBA who has many TB of data, all in MyISAM. On average, 5 days each week are consumed by… remember that your application is probably tuned to work with MyISAM. Just as your application would not work well with Oracle…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…’m curious how you’re dealing with repairing of these MyISAM tables or are you switching to the slave because you… course you do not as you would not be using MyISAM if you would. You still did not answer WHY you… based standby 2) Data corruption with crash. Switch to the slave. 3) Hacker break in or developer trashes the data – switch to time…
Comment: MySQL 5.1 Command line client improvements
June 18, 2007 By 11 Comments
Moazzam, Please report it as a but KILL for the query should not cause data corruption. It would be OK to abort the query and have partially executed insert for MyISAM tables but if index gets corrupted it is surely a bug.
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… having only one IO at the time if Innodb or MyISAM tables are used. There is read-ahead functionality but usually… redundant the Firmware may have a glitch causing failure and data corruption (and this is not just a speculation, some clients really… minimize recovery time significantly by switching to that backup – no data copy will be required which can be significant concern to…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…Performance. MyISAM Corruption – If you’re writting to MyISAM tables there is very large chance of them becoming corrupted during the crash. Note corruption …you may experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should write …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… Your InnoDB table was corrupt and mysql shuts down Your server or RAID controller crashes and all data is lost on that… lose an entire server due to hardware failure, corruption, etc When the majority of data on the server was lost. e.g… – compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped. We are…
