On Wed, Aug 20, 2003 at 10:41:54PM -0500, Dan Nelson wrote:
> 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.
Not yet. But that's supposed to be under development now.
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 4.0.13: up 19 days, processed 959,687,607 queries (567/sec. avg)