… the network. If you backup to an NFS mount from your database server, and then use a different server that also mounts… this happens, xtrabackup will potentially see corrupt or inconsistent data. And InnoDB does not tolerate that. It will refuse to work, which… want help with that.) You can solve this by mounting NFS synchronously on the database host. This is slower for general…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
… number of people run their databases on NetApp and other forms of NFS storage and this post is about one of discoveries in… even with binary log stored on NFS volume. This number is for sync_binlog=0 and innodb_flush_log_at_trx_commit=2… know if someone else can observe such behavior and if there is an NFS tuning which can be done to avoid it…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… 5000. If you’re using innodb_thread_concurrency this will reduce overhead associated with grabbing and releasing innodb_thread_concurrency slot but will… significant gains unless opening and closing files is expensive operation (such as using MySQL on NFS file system). innodb_data_file_path got…
Post: Making replication a bit more reliable
March 4, 2009 By 14 Comments
… main problem is that InnoDB transaction state and replication state are not synchronized. If we speak about backup and you can execute SHOW…. Look for example Sun Storage 7410, which provides storage via NFS and where you can make ZFS snapshots without any info what… have writes exclusively to InnoDB storage engine, case with mix of storage engines is much more complex and I do not see…
Comment: How to decrease InnoDB shutdown times
April 15, 2009 By 20 Comments
… a server. The patches to use include innodb_io_capacity, more background IO threads and a few others. Writes to files in the OS buffer cache are fast. Writes may be slow when: * using innodb_flush_method=O_DIRECT * disabling SATA writeback cache * not using a HW RAID disk cache * using NFS or some…
Comment: Storing MySQL Binary logs on NFS Volume
August 3, 2010 By 19 Comments
… the first place. Default InnoDB/MySQL doesn’t report IO latency — I think Percona Server does and I know the Facebook patch… is much faster than binlog sync to NFS. Given the lack of group commit in InnoDB that can make a huge difference.
Comment: Using LVM for MySQL Backup and Replication Setup
December 20, 2011 By 53 Comments
…tariq Why not buy a cheap NAS of say 5T and mount it on a MySQL slave. Then you have oodles… historical backups there. You could also share it as an NFS export to all the other MySQL slaves. There is also… a read-write snapshot can be directly mounted and then you can let InnoDB recovery do it’s thing. Only way is…
Comment: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
… NFS, etc? Is it reasonable to generalize a benchmark like this and say: Looks like noop is the best scheduler for an INNODB server? Or is this a case of run it yourself and…
