Accelerate mysql index query using an ssd Hard Disk

Use an ssd hard disk to accelerate mysql index query. If the data volume is large but the ssd capacity is not large, you can consider storing the index data on the ssd, store the table data on the old hard disk. So how can mysql build index on ssd and use index data on ssd? 1. create several directories on ssd: mkdir/ssd/mysql_indexesmkdir/ssd/mysql_indexes/my_big_db_namechmod 700/ssd/mysql_indexeschown-R mysql: mysql/ssd/mysql_indexes 2. using the MyISAM engine, you can add the following configuration in mysql configuration to accelerate index reconstruction [mysqld] myisam_repair_threads = 10 3. finally, run the following query to change the INDEX data location of the mysql TABLE: alter table my_table index DIRECTORY = '/ssd/mysql_indexes/my_big_db_name'. After the INDEX of mysql is rebuilt, only then can we clearly feel that the database is getting faster.