Any thoughts on what to do if the InnoDB log gets corrupted? Story behind the question: MySQL hit a bad sector during… ib_logfiles. MySQL outright crashed (there was something in the log about it purposefully generating a segmentation fault so it would…). We ended up recovering from a month-old backup and binary logs, but that was a hassle and took a few weeks…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… goes down) furthermore in case of crash database may become corrupted, just as with MyISAM, and you might need to repair… effect of it is yet unknown – how transactional system implements logging and dirty buffers flushing has serious impact on performance. The… too much overhead as XA already used for synchronizing with binary log. The focus of PBXT and one if it strengths seems…
Comment: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… reasons are: – Bad memory or MySQL Bugs on Primary can corrupt storage… which will be replicated by DRBD – Long switch time… binary logs only rather than for database. In this case secondary node (which is slave at the same time) can use these logs…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
… backup setup only takes you to the point where last binary log was backed up. I wanted for a chance to write… case they will be zeroed out and your data potentially corrupted. This is why I prefer to know files affected by…
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
February 22, 2011 By 21 Comments
Kyle, It looks like you either have wrong position (for whatever reason) or binary log is corrupted for some reason. It is unlikely you really have 1.5GB packet.
Comment: Data Corruption, DRBD and story of bug
November 30, 2010 By 6 Comments
… people need to ensure even database/OS/FS bugs causing corruption and replicated by DRBD are not causing downtime – for these… failures… RAID is good enough for them, probably with streaming binary logs. And if whole box melts down… one can resort to…
Comment: Using LVM for MySQL Backup and Replication Setup
March 20, 2007 By 53 Comments
… of the data in cache. I am running InnoDB with binary logs, all stored on the same LUN/Volume. The snapshot is… snapshot while someone is using the database it may cause corruption or data loss. Do you have any advice?
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…log_info was renamed to innodb_recovery_update_relay_log. (Yasufumi Kinoshita) Old system variable innodb_pass_corrupt_table was renamed to innodb_corrupt…, please see the following links: Downloads – binary distributions and Percona Software Repositories Installation instructions Consulting…
Comment: Returning to InnoDB scalability
August 7, 2006 By 42 Comments
…_pool_size=3G =================================================== =================MySQL error log=================== 060804 20:56:56 InnoDB: Started; log sequence number 45 3475747758 060804… possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or …
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… the XtraDB changed page tracking log files. In addition to the –debug build option for build-binary.sh script, new –valgrind option… #1105726 (Laurynas Biveinis). Time in slow query log was displayed incorrectly when slow_query_log_timestamp_precision variable was set to microseconds… page, except the first one, would result in a heap corruption. Bug fixed #1111226 (Laurynas Biveinis). Fixed the upstream bug #67504…
