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 data
TECTED]>
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
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 preallocat
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 Oracl
> -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 Tables
ohnson, 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 pa
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
er, not an app user.
Brian
-Original Message-
From: Andy Jackman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 2:29 AM
To: Johnson, Michael
Cc: MySQL Users
Subject: Re: Oracle DBA here looking for advice on MySQL
I've used a lot of Oracle, some MS Access and I'
19, 2003 9:48 AM
> To: 'Andy Jackman'
> Cc: MySQL Users
> Subject: RE: Oracle DBA here looking for advice on MySQL
>
>
> I went thru the documentation this weekend on it and found
> that there is really not to much to this database. One thing
> we learn as Orac
ubject: RE: Oracle DBA here looking for advice on MySQL
I went thru the documentation this weekend on it and found that there is
really not to much to this database. One thing we learn as Oracle DBA's
is
how the whole database starts up and how all those processes work
together
and where to f
didnt see
any of that in the MySQL docs I read.
I appears that MySQL has some potential though.
Mike
-Original Message-
From: Andy Jackman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 12:29 AM
To: Johnson, Michael
Cc: MySQL Users
Subject: Re: Oracle DBA here looking for advi
I've used a lot of Oracle, some MS Access and I'm newish to MySQL. I
found it easy to write an abstraction layer for Ms Access and Oracle
despite their different approaches to some important things. I find
MySQL very sparse by comparison and I spend more time working round the
db than working with
Johnson, Michael unknowingly asked us:
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. ?
Doesn't the documentation help?
--
Think to think more, work to work more.
_
13 matches
Mail list logo
