Hello! In your opinion, what is the best file system to run a server database ASA9 in linux? What should I consider to make the most agile possible? Thank you. |
While generic test comparison results may be useful as a "rough guide", it's important to remember that no matter which performance test result you may see, it's not representative of your workload for your data on your server hardware (and even more specifically for filesystems, on your media device). Hence, the most accurate answer is to compare the filesystem timings for yourself on a representative performance test. From: http://sqlanywhere-forum.sap.com/questions/12501/how-to-size-a-machine-for-sqlanywhere-with-1000-connections/12512
For the filesystem comparison case, you want to hold all other performance factors constant (e.g. ensure you start with the same database and static cache options) and only change the file system that the test database is hosted on. |
Here's a comparison of Linux filesystem performance from June 2012: BTRFS vs EXT3 vs EXT4 vs XFS performance on Fedora 17. It recommends EXT4 for databases. |