Mysql versions of stuff i know in MSSQL

[SQLScholar]

Hey all,

I am an MSSQL DBA but i am helping out a friend with Mysql. In MSSQL I maintain my indexes by rebuilding\reorganising as required.

How do you do this in Mysql (to stop index fragmentation)?

Also in MSSQL i will run profiler to capture all the queries against the server and run that into performance tuning advisor to start with to get some good indexes (i analyse it by hand later).

How can i do something similar in mysql?

Many thanks for your advice to a Mysql newbie.

Dan

----------------------------------------

http://www.cardboardcoder.com

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[DonQuichote]

You can use the command-line utility mysqlcheck to do an "optimize" for one table, a database or all databases.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)