MySQL Forums
Forum List  »  Newbie

MySQL tablespace usage to distribute tables in more disks
Posted by: braian Braian
Date: August 09, 2018 01:46PM

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.

Options: ReplyQuote


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.