MySQL Forums
Forum List  »  InnoDB

Re: multiple files per tablespace of a table
Posted by: Rick James
Date: September 14, 2013 11:30AM

If you are building a single table that is too big to fit on a modern disk subsystem, then let's discuss that in more detail. How big will the table become? What kind of data is in it? What SELECTs do you plan to use? Etc.

That is, you will have problems other than tablespaces; and the cure will probably reach back into the overall design of the system.

I see tables (and their .ibd files) that are in the hundreds of GB. No problem. Over 1TB is rare, but "not a problem". (This ignores the _days_ it would take to load the table and the _hours_ it would take to do any non-trivial SELECT. Disks have limited speed!)

Options: ReplyQuote


Subject
Views
Written By
Posted
1956
September 10, 2013 07:17AM
Re: multiple files per tablespace of a table
815
September 14, 2013 11:30AM


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.