MySQL Forums
Forum List  »  Newbie

Re: engine INNODB does not support the create option TABLESPACE
Posted by: Maurice Correa
Date: April 12, 2015 11:25AM

Let me back up a bit. Our application is an enterprise type of application that serves as a platform for other companies, usually System Integrators, to build complete composite solutions. As such, some of our customers do millions of transactions per day. I could say that the ratio is about 50/50 between reads and writes and some of the tables grow very large. As with other databases, tablespaces are used to segregate or separate some tables into their own spaces and files for better performance. This concept of storage engines is new to us and we are trying to figure this out...hopefully with you guys help. We need to know what engine to use how to use it (e.g., do we need to use tablespaces or not, and anything else that we should know). At least what engine to use would be very helpful. Thanks again!

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.