MySQL Forums
Forum List  »  Newbie

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


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

Written By
MySQL tablespace usage to distribute tables in more disks
August 09, 2018 01:46PM

Sorry, only registered users may post in this forum.

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.