…, surviving power failures and even partial page writes but still they can get corrupted because of MySQL bugs, OS Bugs or hardware… allow per table backup and recovery to happen faster. With MySQL and blocking ALTER TABLE there is yet another reason to… might not have. You can of course use MASTER-MASTER replication and run statement on one server, switch role and then…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… get to deal with recovering tables on the crash or partially executed statements. Table locks is no more problem, hot backups… the MySQL server – in particular Optimizer may have harder time because costs between storage engines may not be well balanced or replication…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…bound or CPU bound, while to understand if MySQL goes through more rows than it needs …more specific. Lets look at update queries (from replication thread for example). When update is performed …disk which has the data (even keeping aside partial “border” IO request which will require reading both …
