… – users may issue different queries which may trigger check/repair running for many tables at onces, which typically make system extremely slow…. In MySQL 5.0 XA is taking care of this synchronization. .frm Corruption – Few people know MySQL is not really ACID even with Innodb tables…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
…repair table by running ALTER TABLE with limited impact to production system (as only one table…corrupted tables (in this particular corruption instance Innodb did not print table name in question), drop tables, restart Innodb without innodb…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…tables) Innodb was better choice mainly because of thouse other behaviors … well table…repair the table you will very likely observe very serious corruption…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…table parsing. In that case, I suspect you will certainly NOT have the time for a REPAIR TABLE on your MyISAM’s corrupted table…. You’ve has a review by a MySQL consultant. I’m assuming the review was professional…. If the above sounded like a “always use InnoDB” preach, that was not my intent. I …
Post: Small things are better
October 8, 2006 By 15 Comments
… repairing took many hours especially as automatic check on boot failed and had to be manually restarted. Same may happen with Innodb tables… corrupted because of MySQL bugs, OS Bugs or hardware bugs, misconfiguration or failures. Sometimes corruption kind be mild, so ALTER TABLE to rebuild the table…
Post: Monty unviels Maria and starts Blogging
January 29, 2008 By 4 Comments
…level locks functionally close to Innodb or Falcon. Though many …repair tables from the very first versions as well as has tables movable…theory never is corrupted and database maintains consistency between tables so you…engine of choice for future MySQL. Again, Congratulations Monty, these are both…
Comment: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… memory or MySQL Bugs on Primary can corrupt storage… which will be replicated by DRBD – Long switch time even for Innodb tables – on large… performance. – Pretty much unusable for MyISAM tables which may take infinity to check and repair – Waste of hardware as Secondary node sits…
Comment: MySQL Crash Recovery
October 12, 2007 By 30 Comments
gigiduru, If MySQL crashed in your case that is a but and it does not normally happen. Regarding MyISAM locking and corruption it is a choice – if you want want table locks and repair after server crash you go with MyISAM if you want transactions and multi versioning you go with Innodb.
