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.
The InnoDB storage engine 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]
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
