O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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
  1. Create a table:
mysql> CREATE TABLE event_tracker (event_id INT UNSIGNED AUTO_INCREMENT ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required