List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:August 21 2003 7:58am
Subject:Re: Oracle DBA here looking for advice on MySQL ....
View as plain text  
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)
Thread
Oracle DBA here looking for advice on MySQL ....Michael  Johnson19 Aug
  • Re: Oracle DBA here looking for advice on MySQL ....Rajesh Kumar19 Aug
  • Re: Oracle DBA here looking for advice on MySQL ....Andy Jackman19 Aug
    • RE: Oracle DBA here looking for advice on MySQL ....Brian Austin20 Aug
  • RE: Oracle DBA here looking for advice on MySQL ....Adam Nelson20 Aug
    • Re: Oracle DBA here looking for advice on MySQL ....Martin Gainty21 Aug
      • RE: Oracle DBA here looking for advice on MySQL ....Michael S. Fischer21 Aug
        • RE: Oracle DBA here looking for advice on MySQL ....Paul DuBois21 Aug
        • Re: Oracle DBA here looking for advice on MySQL ....Dan Nelson21 Aug
          • Re: Oracle DBA here looking for advice on MySQL ....Jeremy Zawodny21 Aug
        • Re: Oracle DBA here looking for advice on MySQL ....David Griffiths21 Aug
RE: Oracle DBA here looking for advice on MySQL ....Michael  Johnson19 Aug
  • RE: Oracle DBA here looking for advice on MySQL ....Wendell Dingus19 Aug
  • RE: Oracle DBA here looking for advice on MySQL ....Michael S. Fischer19 Aug