MySQL tablespace usage to distribute tables in more disks
Hello,
I need to distribute a database between two disks. It needs to be done because I need to create a new table that will receive a lot of data and will generate a lot of IO.
I believe that moving this data to another disk will avoid problems of IO Wait and performance.
I tried to create a tablespace, but the following error occured:
mysql> CREATE TABLESPACE `ts1` ADD DATAFILE '/tsdatafiles/ts1.ibd' Engine=InnoDB;
ERROR 1528 (HY000): Failed to create TABLESPACE ts1
This tablespace is just to test and learn how to work with tablespaces. So, someone can help me telling what I'm doing wrong and if there is an more eficiente way to make it works?
Thank you for the help.
Subject
Written By
Posted
MySQL tablespace usage to distribute tables in more disks
August 09, 2018 01:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.