Comments - Does MariaDB support multiple data directories within a single instance?
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
You must use inno_db_file_pre_table which keeps the data for each table in a specific file for that table.
Turn on inno_db_file_pre_table, Rebuild your table (ALTER TABLE foo ENGINE=INNODB) Shut down your DB Move the file for that particular table to your special disk / storage device and symlink it from the original location (the DATA DIRECTORY) to the new location. (Make sure the files and symlinks are owned by mysql) Start your DB.
This will work as you expect.