RE: Slightly OT - Mysql Training

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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_at_gmail.com> 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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 14 2007 - 12:14:14 CDT