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
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
