List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 21 2003 3:41am
Subject:Re: Oracle DBA here looking for advice on MySQL ....
View as plain text  
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
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