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.
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 or SELinux, make sure you set the alias or context correctly:
shell> sudo chown -R mysql:mysql /var/lib/mysql_fast_storage shell> sudo chmod 750 /var/lib/mysql_fast_storage
- Create a table:
mysql> CREATE TABLE event_tracker ( event_id INT UNSIGNED AUTO_INCREMENT...