Additional storage devices could be used to set up a RAID configuration. For related information, see Section 8.12.1, “Optimizing Disk I/O” . 

Alternatively, InnoDB  tablespace data files and log files can be placed on different physical disks. For more information, refer to the following sections: 

•Section 15.8.1, “InnoDB Startup Configuration” 

•Section 15.6.1.2, “Creating Tables Externally” 

•Creating a General Tablespace 

•Section 15.6.1.4, “Moving or Copying InnoDB Tables” 

•Consider non-rotational storage 

Non-rotational storage generally provides better performance for random I/O operations; and rotational storage for sequential I/O operations. When distributing data and log files across rotational and non- rotational storage devices, consider the type of I/O operations that are predominantly performed on each file. 

Random I/O-oriented files typically include file-per-table and general tablespace data files, undo tablespace files, and temporary tablespace files. Sequential I/O-oriented files include InnoDB  system 

