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
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
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
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 datafile,
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
]; '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
-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
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
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 advice
: 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 find bottlenecks
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 Oracle DBA's is how the whole database starts up
and how all those processes work together
, not an app user.
/opinion per 1st reply
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
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