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_storageshell> sudo chmod 750 /var/lib/mysql_fast_storage
- Create a table:
mysql> CREATE TABLE event_tracker (event_id INT UNSIGNED AUTO_INCREMENT ...