In the previous section, you understood how to create a system tablespace in another disk. In this section, you will learn how to create an individual tablespace in another disk.
Creating file-per-table tablespaces outside the data directory
How to do it...
You can mount a new disk with particular performance or capacity characteristics, such as a fast SSD or a high-capacity HDD, onto a directory and configure InnoDB to use that. Within the destination directory, MySQL creates a subdirectory corresponding to the database name, and within that, a .ibd file for the new table. Remember, you cannot use the DATA DIRECTORY clause with the ALTER TABLE statement:
- Mount the new disk and change the permissions. If you are using AppArmour...