MySQL Forums
Forum List  »  Newbie

Re: engine INNODB does not support the create option TABLESPACE
Posted by: Rick James
Date: April 12, 2015 03:04PM

Tablespaces is an old fashioned way to get disk performance. RAID striping is better, especially if it has a Battery Back Write Cache.

InnoDB and NDB are two different ways to use MySQL; they are mostly similar to the 'user' and radically different when it comes to deploying it (hardware, configuration, tuning, etc).

A few million 'small' transactions per day is no problem for either engine.

Operating systems have techniques for adding disk space after the fact. Suggest you look into that.

Options: ReplyQuote




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.