Hi, I have tried BTRFS from Ubuntu 16.04 LTS for write intensive OLTP MySQL Workload.
It did not go very well ranging from multi-seconds stalls where no transactions are completed to the finally kernel OOPS with "no space left on device" error message and filesystem going read only. I'm complete newbie in BTRFS so I assume I'm doing something wrong. Do you have any advice on how BTRFS should be tuned for OLTP workload (large files having a lot of random writes) ? Or is this the case where one should simply stay away from BTRFS and use something else ? One item recommended in some places is "nodatacow" this however defeats the main purpose I'm looking at BTRFS - I am interested in "free" snapshots which look very attractive to use for database recovery scenarios allow instant rollback to the previous state. -- Peter Zaitsev, CEO, Percona Tel: +1 888 401 3401 ext 7360 Skype: peter_zaitsev -- To unsubscribe from this list: send the line "unsubscribe linux-btrfs" in the body of a message to majord...@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html
