In the last episode (Feb 03), Prasanth Krishna said:
> Is there any concept of Tablespace for MyISAM tables in MySQL? Even
> if it is not present, is there any concept in MySQL which is
> equivalent to Tablespace in Oracle?
MyISAM tables are stored as separate files in the filesystem, so you
could think of each table as having two "tablespaces"; one for the data
(table.MYD), and one for the index (table.MYI).
InnoDB tables are stored in tablespaces just like Oracle, except there
is only one global tablespace and you can't specify that table A and
table B go into different files.
|• tablespace||Prasanth Krishna||3 Feb|
| • Re: tablespace||Dan Nelson||3 Feb|