At 17:24 -0700 8/20/03, Michael S. Fischer wrote:
>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:mgainty@stripped]
>> 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" <adam@stripped>
>> To: "'Johnson, Michael '" <Michael.Johnson@stripped>;
>> "'MySQL Users'" <mysql@stripped>
>> 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:Michael.Johnson@stripped]
>> > > 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?> unsub=mgainty@stripped
>> >
>> >
>>
>>
>> --
>> MySQL General Mailing
>> List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?> unsub=michael@stripped
>>
>>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
