… a bit with “zfs snapshot script” you’ll many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you… ZFS each record on disk has a checksum. If a cosmic ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will be read from the…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… caching by the file system vs the InnoDB caching. However, limited ARC size also limits ZFS file system’s internal metadata caching…) You need to sacrifice a little ram for ZFS metadata caching to make ZFS fast. NexentaStor recommends minimum 1-2GB ram for…, for a 64x300GB storage system, leaving 20GB for ZFS is worthwhile. (All ZFS systems should max ram slots with 16gb dual rank…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
We’ve been using ZFS on FreeBSD for backup and production for a few years …. Add to that the compression gain from ZFS and there really no cost difference. ZFS provides built in checksumming and double write buffering, so make sure these are turned off in InnoDB.
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_additional_mem_pool_size = 20M innodb_log_file_size = 1600M innodb_log_buffer…. But what really surises me here is why not ZFS ? The ZFS MySQL success story is all over across Sun’s blogs…
Post: SystemTap - DTrace for Linux ?
September 14, 2009 By 17 Comments
… is incompatible with GPL. So you can see DTrace and ZFS on Solaris, FreeBSD, MacOS, but not on Linux. However I…(find_flag=? ) innodb_srv_conc_enter_innodb(trx=? ) srv_conc_enter_innodb(trx=0x2aaaaaddb8b8 ) innodb_srv_conc_exit_innodb(trx=? ) srv_conc_exit_innodb(trx=0x2aaaaaddb8b8…=0x1a6aced0 ) innobase_release_stat_resources(trx=? ) srv_conc_force_exit_innodb(trx=0x2aaaaaddb8b8 ) Again, this case is maybe too simple, but…
Comment: ext4 vs xfs on SSD
April 24, 2012 By 26 Comments
… look at the bug list or patch list for MySQL/InnoDB at any one point in time. The list will be… common decency. That’s where things like the support of ZFS outside of Solaris comes from… people do technical work of…” in the extreme. The systems I put on-line have ZFS and we rely on it. I can just imagine some…
Comment: Innodb Double Write
January 4, 2010 By 24 Comments
btw: if MySQL is running on ZFS then you can safely disable innodb doublewrites as ZFS always guarantees that either entire write completes or nothing is updated.
Comment: Compression for InnoDB backup
March 18, 2009 By 19 Comments
lzjb Reminds me of discussions in this post: ZFS & MySQL/InnoDB Compression Update http://blogs.smugmug.com/don/2008/10/13/zfs-mysqlinnodb-compression-update/
Post: Effect of adaptive_flushing
December 4, 2009 By 5 Comments
… 40G buffer pool. We started it up with innodb_adaptive_flushing=OFF and innodb_doublewrite=OFF, then ramped up traffic and everything… change in disk IO which mirrors the innodb pages written graph (shown above). I suspect ZFS is heavily buffering writes during the… adjusting innodb_io_capacity here. Is there a lesson in this? Sometimes tuning InnoDB settings can have quite unexpected results…. Setting innodb_adaptive…
Post: Making replication a bit more reliable
March 4, 2009 By 14 Comments
… tricky (if possible at all). The main problem is that InnoDB transaction state and replication state are not synchronized. If we…, which provides storage via NFS and where you can make ZFS snapshots without any info what kind of data you are… course it will work if you have writes exclusively to InnoDB storage engine, case with mix of storage engines is much…
