List:General Discussion« Previous MessageNext Message »
From:Michael S. Fischer Date:August 19 2003 5:29pm
Subject:RE: Oracle DBA here looking for advice on MySQL ....
View as plain text  
Michael,

The reason you think there's not much to this database is that compared
to Oracle, there really is not much to this database.  :-)  

From a 50,000-foot point of view, it's really just a nice SQL interface
to ISAM files (it started out that way, anyway).  It is designed for
high-performance in read-intensive environments, and so it doesn't
really need to be that complicated.

MySQL is a single-process, multithreaded server.  That means you start
mysqld through the wrapper script and that's all that runs.  It doesn't
have separate specialized daemons for doing various tasks like Oracle
and PostgreSQL do.  All data is stored in MyISAM files (assuming you're
not using InnoDB or BDB), two per table (one data, one index file), and
tables are stored in directories corresponding to the database name in
the configured data directory.

Some basic knowledge of system performance tuning for your given OS and
reading the manual, particularly Chapter 5 (MySQL Optimization) should
put you well ahead of the pack.

Best,

--Michael 

> -----Original Message-----
> From: Johnson, Michael [mailto:Michael.Johnson@stripped] 
> Sent: Tuesday, August 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 Oracle DBA's is how the whole  database starts up 
> and how all those processes work  together
> and where to find bottlenecks when things start to bog down.  
>   It 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:ajackman@stripped]
> Sent: Tuesday, August 19, 2003 12: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'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 it. 
> Unlike Oracle the richness and integrity of language is 
> simply missing - these people have lived without something as 
> useful as sub-queries for a long time. (The argument being 
> that speed and data integrity are all-important). It's more a 
> file system than a relational database. I know you asked 
> about books rather than a comparison of the products, but the 
> software philosophy is reflected in the documentation. If 
> someone else pays you to be an Oracle Dba then I bet you have 
> at least a 10 foot shelf of comprehensive documentation. This 
> list is about as good as it gets (see your previous 
> response). There is a PDF copy of the manual somewhere and 
> setting up MySql was accompilshed by a colleague who wouldn't 
> have known where to start with Oracle, so it has that in its favour.
> 
> So, if you're thinking of migrating, think carefully! If I 
> could get Oracle to give me a sensible price (say USD 1000) 
> to sell their db with my product I would be out of here so 
> fast. So far with mySQL i've written my own database for a 
> particular (simple) structure that it wouldn't handle to my 
> satisfaction; I've written my own date/time routines to 
> calculate things like seconds between 2 datetimes (despite a 
> wealth of datatime functions, this one isn't available unless 
> you convert to 'Unix' dates which expire in 2036) and I've 
> written functions to handle the fact that in 'C' all data is 
> returned as strings rather than as native data types. Sigh.
> - Andy
> 
> "Johnson, Michael" wrote:
> > 
> > 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=1
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?> unsub=michael@stripped
> 
> 

Thread
Oracle DBA here looking for advice on MySQL ....Michael  Johnson19 Aug
  • Re: Oracle DBA here looking for advice on MySQL ....Rajesh Kumar19 Aug
  • Re: Oracle DBA here looking for advice on MySQL ....Andy Jackman19 Aug
    • RE: Oracle DBA here looking for advice on MySQL ....Brian Austin20 Aug
  • RE: Oracle DBA here looking for advice on MySQL ....Adam Nelson20 Aug
    • Re: Oracle DBA here looking for advice on MySQL ....Martin Gainty21 Aug
      • RE: Oracle DBA here looking for advice on MySQL ....Michael S. Fischer21 Aug
        • RE: Oracle DBA here looking for advice on MySQL ....Paul DuBois21 Aug
        • Re: Oracle DBA here looking for advice on MySQL ....Dan Nelson21 Aug
          • Re: Oracle DBA here looking for advice on MySQL ....Jeremy Zawodny21 Aug
        • Re: Oracle DBA here looking for advice on MySQL ....David Griffiths21 Aug
RE: Oracle DBA here looking for advice on MySQL ....Michael  Johnson19 Aug
  • RE: Oracle DBA here looking for advice on MySQL ....Wendell Dingus19 Aug
  • RE: Oracle DBA here looking for advice on MySQL ....Michael S. Fischer19 Aug