MySQL 8 Cookbook

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:

1. 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

2. Create a table:

mysql> CREATE TABLE event_tracker (event_id INT UNSIGNED AUTO_INCREMENT ...