Our client is asking some document regarding MySQL database filesystem best practices, could you please share information about that.
MySQL Database filesystem standard
MySQL
Related Question
- MySQL execute statement returns ‘NULL’
- MySQL – Should innodb_file_per_table Be Enabled for Single Tenant SaaS?
- Database Storage – Integrating Filesystem Storage with MySQL/PostgreSQL
- PostgreSQL to MySQL Migration for WordPress Site – How To’s
- Mysql – How to reclaim space after nulling out LONGTEXT records on MySQL
Best Answer
MongoDB recommends XFS in official docs. But MariaDB (and MySQL have no file system best practises/parameter tuning).
Quote from What is the best Linux filesystem for MariaDB?
Don't forget to mount fs with
noatime
.