That's not entirely correct. InnoDB currently supports a single tablespace (comprised of multiple datafiles).
Heikki Tuuri (the developer and maintainer of InnoDB) also mentioned that multiple-tablespace support might be in InnoDB this fall (September 2003 according to the TODO list at InnoDB: http://www.innodb.com/todo.html). As an Oracle DBA (I'm one myself), InnoDB will give you "close to Oracle" features. As an FYI, we also spent alot of time looking @ Postres and SAPDB. Postgres is a great database engine, and would be very adequate if it didn't have one significant missing feature - there is no replication or standby support unless you buy an expensive licence (which brings the cost close to that of Oracle); we need the high-availability of clusters and replication. Both Postgres and MySQL have great support via their mailing lists, but once in a while, the people on the Postgres mailing list decide to kick MySQL around a bit; I think they have an inferiority complex. SAPDB is a mess right now and the documentation is atrocious; hopefully the MySQL developers can clean it up. It also doesn't have replication (though it has utilities and features that imply replication via their name; the latest version renamed them, with a comment that it wasn't really replication). MySQL, with InnoDB and replication, is better than either for what we need. David. ----- Original Message ----- From: "Michael S. Fischer" <[EMAIL PROTECTED]> To: "'Martin Gainty'" <[EMAIL PROTECTED]>; "'MySQL Users'" <[EMAIL PROTECTED]> Sent: Wednesday, August 20, 2003 5:24 PM Subject: RE: Oracle DBA here looking for advice on MySQL .... > 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. > > --Michael > > > -----Original Message----- > > From: Martin Gainty [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 20, 2003 2:20 PM > > To: 'MySQL Users' > > Subject: Re: Oracle DBA here looking for advice on MySQL .... > > > > > > As a Oracle followup question > > Oracle supports Tablespaces > > That is > > 2 or more logically separate entities for System Data and User Data > > > > Does MySQL have Tablespace support? > > > > Many Thanks, > > Martin > > ----- Original Message ----- > > From: "Adam Nelson" <[EMAIL PROTECTED]> > > To: "'Johnson, Michael '" <[EMAIL PROTECTED]>; > > "'MySQL Users'" <[EMAIL PROTECTED]> > > Sent: Wednesday, August 20, 2003 7:49 AM > > Subject: RE: Oracle DBA here looking for advice on MySQL .... > > > > > > > I'd say MySQL 2nd edition by Paul Dubois. It has the first > > 200 pages > > > with stuff you already know, but the next 800 pages are mysql > > > specific. Very good reference book and best practices guide. > > > > > > The only thing it's missing is what I think should be in every book > > > (and is in virtually none). 5 pages devoted to the initial > > setup of > > > the program on each major OS. It's such a simple thing, but often > > > there are very competent individuals who just want to read the best > > > practices setup in concise form. Then, when more time is > > available, > > > go back and tweak, etc.. > > > > > > > > > > > > > -----Original Message----- > > > > From: Johnson, Michael [mailto:[EMAIL PROTECTED] > > > > Sent: Monday, August 18, 2003 6:43 PM > > > > To: MySQL Users > > > > Subject: Oracle DBA here looking for advice on MySQL .... > > > > > > > > > > > > What is the best book on MySQL with regard > > > > to its Architecture and how it starts up, shutdowns, processes > > > > queries, rolls back data, etc etc. ? > > > > > > > > I am not looking for a SQL book here. > > > > > > > > What is the best My SQL book you have read ? > > > > > > > > Thank you in advance. > > > > > > > > Mike > > > > > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > > > > > > > > > > > -- > > MySQL General Mailing > > List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
