Any tips for an MS SQL DBA trying to break into MySQL?

[Sam Alexander]

Hi everyone,

I've been an MS SQL developer for over a decade now, but other than using MySQL on a few sites I maintain I've never really learned the nuts and bolts of MySQL. Some questions for anyone who's gone down this same path or who works in both worlds:

- Is there an SSMS type tool for MySQL? I've tried MySQL Workbench but it just seems clunky. Also if possible i"d love to find something that works in Windows, Linux, and OSX since I live in all three worlds.
- Can someone recommend books or online resources about indexing and performance tuning?
- I use Microsoft SQL Server Reporting Services and love it, is there any equivalent tool for MySQL whether by Oracle or someone else?
- What about equivalent troubleshooting tools in MySQL like these in MS SQL: information_schema, SQL Profiler, DBCC SHOWCONTIG, etc.
- Also any good books or resources showing how MySQL works under the hood? I'm familiar with the tree/leaf method of how MS SQL works with indexes but what about MySQL?
- What about data warehousing? MS SQL has Analysis Services, but are there any tools either built into MySQL or maybe industry standard tools for business intelligence?

Thanks in advance for any pointers or tips. Take care,

Sam