RE: Slightly OT - Mysql Training
- From: "Mary Bahrami" <mbahrami@xxxxxxxxxxxxxxxx>
- To: <weaver1308@xxxxxxxxx>, "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 14 Mar 2007 10:14:14 -0700
I recently took the MySql for DBA's class and agree that it was a waste
of time; it was geared to people new to databases in general and the
instructor couldn't answer many questions outside the class material.
I also took the performance tuning class, which was taught by a guy who
had worked in the mysql performance group and done consulting. He was
excellent, and could discuss differences between oracle, sql server, and
mysql optimizers, etc.
The best way to get up to speed is to install mysql and use the
extensive docs at mysql.com (check the user notes at the bottom of each
page, one corrected the spelling of a system variable). Diffs from
oracle I had to research were binlog handling (they don't rotate
automatically) and handling > 1 install per server. The slowquery log
is nice.
The optimizer is a bit funny, use 'explain' a lot while you learn.
mysql 5.0 did a FTS for the statement "select * where col1=5" ....col1
is defined as a varchar column. Buried in the performance class notes
is the statement 'avoid implicit conversions', with no further
explanation.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Walt Weaver
Sent: Wednesday, March 14, 2007 7:50 AM
To: Oracle Discussion List
Subject: Re: Slightly OT - Mysql Training
An inexpensive way to start would be to buy the book _MySQL_ by Paul
DuBois.
We recently sent a guy to the "MySQL for DBA's" class and he pronounced
it pretty much a waste of time.
In my experience picking up MySQL after working with Oracle is more like
taking on more "SysAdmin-ish" skills and responsibilities than new DBA
ones. On the surface there isn't really much to learn and you can pretty
much hit the ground running with it.
But, if you have the money to spend on a class, go to the annual MySQL
Conference, which will be happening in about a month (in Santa Clara).
The last couple of years they've had quite a few seminars with an Oracle
vs. MySQL theme and were interesting.
And, if you start using MySQL in production extensively like we do you
will discover that the MySQL optimizer and database engine has "quirks"
that will keep you, um, busy on the database side of things.
--Walt
On 3/13/07, rjamya <rjamya@xxxxxxxxx> wrote:
Does anyone has recommendations for good mysql training (instructor led
will be fine) for a oracle dba? No time to sit down and experiment and
learn by myself. Preferable in the NE region (or Hawaii).
TIA
RJamya
-------------------------------------------
Other related posts:
