… here. Same as during last time I will provide my comments for some of the answers under PZ and will use… compact row format was implemented which can help performance (keeping data smaller) or can a bit slow it down. Plus there… switch to Oracle? HT: You are right, bugs that cause data corruption, crashes, or wrong query results get the highest priority. We…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… to have so many great comments. I also understand that people, including myself, do…code. I have seen way more replication corruption issues than InnoDB corruption ones. Looking at the other …@Todd: Replication are two different ways of replicating data, from my experience, DRBD is more reliable than…
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
Jim, Thank you very much for your comments. Spinlocks: I see you use Windows terminology. Would be interesting … reasons, ie tracing bad memory or hardware melt down before corruption spread all around database. Some other techniques however are needed… data again and version is not in memory any more, or you may throw an error. Blob Handling: Just regarding your comment…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… and above, probably you have more than 1TB of data. You say you cannot afford the restoration time from … time for a REPAIR TABLE on your MyISAM’s corrupted table. You say you need to prepare for a “…. …” I think Peter summed it up very well in comment #18. If the above sounded like a “always use …
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… few days worth of planet MySQL and commenting on some entries as you can see. The post… Furthermore as I remember MySQL simply was not repairing corrupted tables in this configuration even if myisam_repair …better idea but may be the problem is your data is so large you can’t afford multiple copies …
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
… of argument) but the problems can be subtle and silently corrupt your data. Aside from not dealing with dependency issues, running with… MySQL server installed? UPDATE: Peter and Sergei suggested on the comments that 3rd party specialized repositories might have been not explicitly…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… documentation from the release notes: “InnoDB Storage Engine: Data from BLOB columns could be lost if the… the record update, the index tree would be corrupted. The correct solution is to make the freed…) to avoid leaking pages. row_build(): Correct a comment, and add a debug assertion that a record …
Comment: Linux schedulers in tpcc like benchmark
October 27, 2009 By 19 Comments
…/s (exploded once with corrupt data when changing scheduler) EXT2+noop: 97MB/s XFS+cfq: 30MB/s Some comments on this setup: – XFS…
