… systems like XFS will not continue if consistency problems are discovered. So how can you check what error behavior mode your file system…: has_journal ext_attr resize_inode dir_index filetype needs_recovery extent 64bit flex_bg spars e_super large_file huge_file uninit… filesystem data structures which may be affects one file will take out whole file system. I do not think these concerns are valid…
Comment: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… even in this case it is going to help the journaling file system you’re likely to use. I am also not sure… corrupt Innodb database and even with MyISAM you’re risking journaling file system corruption. File system cache is removed from equation because of use of…
Post: Small things are better
October 8, 2006 By 15 Comments
… had “journal failed” message in kernel log and filesystem needed to be checked and repaired even though it is journaling file system which should… RAID volumes would typically rebuild faster, smaller database size per system (yet another reason to like medium end commodity hardware) makes…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… a Unix-like OS? If so, what file system are you using? Unjournalled, like ext2, or journaled, like ext3, xfs? If you’re running Windows, do you useFAT32 of NTFS? I suspect you’re using journaled file systems, although…
Comment: Why you can't rely on a replica for disaster recovery
August 7, 2010 By 25 Comments
… the DB and the fileystem. The most common linux file systems like ext3 are journaling file systems and as such they very, very, very rarely… realm of possibility. Point being I suppose is that modern file system almost always survive a crash, so we tend to take… testment to some very careful file system design. The fact that a database running on top of that file system recovers as well is…
Comment: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
You may also want to try tmpdir on ext2 (or a journaling file system with external journal on a ramdisk or /dev/null). This has the benefit of supporting larger than free memory files… and writes could be better than if in the case of tmpfs, being swapped out.
Comment: Why you can't rely on a replica for disaster recovery
August 16, 2010 By 25 Comments
…”? I think pretty much everyone agrees that using a non-journaling file system is a really bad idea if you want any resilience…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… or have some systems with similar features set for other operation systems. Veritas File System can do it for Solaris. Most SAN systems would work… benefits. First no extra handling is needed for journaling file sytems – you can simply do journal recovery on snapshot. With read-only snapshot…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… Innodb storage engine. Moreover these operation could cause (depending on file system and configuration) more synchronous IO operations – MySQL binary logs are… synced to avoid data loss. Though in case of “data journaling” this can be done with single log write with actual… in this case we investigated the system and the “surprising” overhead of DRBD perfectly matched system components performance capacity. As a lesson…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
… performance when sync-binlog=1 is enabled, even though the system with RAID and BBU were expected to have much better… sync-binlog=1 We tried running data=writeback and data=journal just to make sure but results were basically the same… this regard as it is by far the most common file system for Linux. It is also worth to investigate if something…
