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! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 959,687,607 queries (567/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
