… but… since it is a copy on write filesystem, the snapshots are free, no performance penalty. You…ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the…yet interesting saving. All put together, ZFS on Linux is a very interesting solution for MySQL backup servers…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…from one machine to another and configured with Linux network interface bonding in balance-rr mode; this…except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say…grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… down the to the tablespace. If Innodb stops (read: crashes) with dirty buffer pool pages, Innodb recovery must be done to rebuild… still useful if you can use Linux native AIO. These can also be rendered useless by filesystems that don’t allow parallel…/or use the global tablespaces) *cough ext3 cough*. innodb_adaptive_flushing: An Innodb plugin/5.5 setting that tries to be smarter…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… extra_isize Filesystem flags: signed_directory_hash Default mount options: user_xattr acl Filesystem state: clean Errors behavior: Continue Filesystem OS type: Linux Inode… any of file system errors are reported back to MySQL/Innodb it will assert and restart. Now lets look at couple…
Comment: Is there room for more MySQL IO Optimization?
January 9, 2013 By 11 Comments
… that filesystems are generally doing prefetch of data blocks more faster than InnoDB, in you particular case it’s also possible that filesystem is involving more parallel I/O reads than InnoDB (and… here is a generally poor FS cache memory management in Linux + endless I/O buffering on many levels.. – while the most…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
…? Yes. Can you have separate partitions for Innodb log volumes, etc.? Sure. Is it work…sda2 * 7813120 27344895 9765888 83 Linux /dev/sda3 27344896 856422399 414538752 83 Linux Several months ago my… on a RAID stripe boundary. Create the Filesystem XFS requires a little massaging (or a lot…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…64 x86_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 (… pvs; vgs; lvs These commands show me what filesystems are mounted, how much space they have on …that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… this later. Free No extra commercial tools as Innodb Hot Backup are required to perform backup. Are… read-only snapshot you need to make sure filesystem synchronizes device before snapshot is taken so no…MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
… now handles non-InnoDB tables. (Vadim Tkachenko) Bug #606981 – Streaming InnoDB files with tar4ibd could lead to filesystem hangs when InnoDB was configured to… file on Linux is disallowed. Fixed innobackupex and tar4ibd to use O_DIRECT on input InnoDB files if the value of innodb_flush…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
…selects=0 –oltp-range-size=0 –mysql-table-engine=innodb –mysql-user=root –max-requests=0 –max-time=60…On Dell R900 with CentOS 5.2 and ext3 filesystem we get 1060 transactions/sec with single thread and…is by far the most common file system for Linux. It is also worth to investigate if something …
