List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:February 3 2003 4:46pm
Subject:Re: tablespace
View as plain text  
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.

-- 
	Dan Nelson
	dnelson@stripped
Thread
tablespacePrasanth Krishna3 Feb
  • Re: tablespaceDan Nelson3 Feb