From: Dan Nelson
Date: August 21 2003 3:41am
Subject: Re: Oracle DBA here looking for advice on MySQL ....
List-Archive: http://lists.mysql.com/mysql/148101
Message-Id: <20030821034154.GA24462@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Aug 20), Michael S. Fischer said:
> In a word, no.  The way MySQL organizes its datafiles is trivial by
> comparison: one directory per database, two files per table (table.MYI
> and table.MYD), one is the datafile, the other is the index file.  MySQL
> also does not preallocate space for its tables like Oracle does.

That's for MyISAM tables.  InnoDB tables do use a tablespace, but it's
one big file for everything, indexes and tables.  You can't create
multiple tablespaces and assign individual tables/indexes/users to
different tablespaces.

-- 
	Dan Nelson
	dnelson@stripped