… 5.3, Xeon E5405, 16GB RAM and EXT3 file system on the SATA hard drive. MySQL 5.0.85 Created 100.000 tables in…/sec – This indicates the “fsync” is lying on this test system as default sync_frm option is used. With default table… which made updates to headers very slow. In the production systems with table headers not in OS cache you often will…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… but beware of random writes to RAID5. Operating System First – run 64bit operating system. We still see people running 32bit Linux on… setup LVM for database directory to get more efficient backup. EXT3 file system works OK in most cases, though if you’re running… you wrestle OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb…
Post: Small things are better
October 8, 2006 By 15 Comments
…fun time repairing 1.5Tb ext3 partition, containing many millions of files. Of course it should …checked and repaired even though it is journaling file system which should not need checks in normal use… still they can get corrupted because of MySQL bugs, OS Bugs or hardware bugs, misconfiguration or…
Comment: ext4 vs xfs on SSD
April 24, 2012 By 26 Comments
… something as important as an Operating System or major component like a File System on the basis of ONE fairly small…look at the bug list or patch list for MySQL/InnoDB at any one point in time. The list…the wall at me. Worse, someone electing to use ext3/4 because of your post. In the second event…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… the right choice. You’ve has a review by a MySQL consultant. I’m assuming the review was professional. But you… 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: Another scalability fix in XtraDB
January 24, 2009 By 13 Comments
… the curve getting fixes right now and often available for MySQL versions which are currently used in production. Note it is… software should have all simple issues worked out. Look at MySQL itself – how could it get through the years with single… kernel with arguably most popular EXT3 file system – which has inode locking for O_DIRECT, basically serializing all concurrent writes to the same file ?
Comment: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 9, 2009 By 32 Comments
… specific or MySQL specific or is it hardware? Does it happen in EXT3 under Linux? If it is a file system issue or MySQL issue…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… facto filesystem for many modern Linux system, I am getting a lot of… it comes to known problem in ext3, where IO gets serialized per i…consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or… –file-num=1 –file-extra-flags=direct –file-fsync-freq=0 –file-io-mode=sync –file-block-…
