Use MyProfiler to :
Monitor the performance of an instance MySql .
Troubleshoot problems in MySql by capturing events on
a production system and replaying them on a test
system. This is useful for testing or debugging
purposes and allows users to continue using the
production system without interference.
Audit and review activity that occurred on an instance
of SQL Server. This allows a security administrator to
review any of the auditing events, including the
success and failure of a login attempt and the success
and failure of permissions in accessing statements and
objects.
Get a full list of the statements executed on your
server and the time of execution. This helps shared
hosts to charge the users by usage .
Helps you detect bottlenecks and determine high usage
days and hours on your server .
Use the Index tuning wizard to determine the best
organization of indexes on your databases .The index
tuning wizard allows gives u a recommendation on
creating the indexes in your tables .
Tracing :
In the tracing window you will see the events that
occur on your server .MyProfiler captures the
following events : SQL Queries -Login attempts-
Shutdown-Connection terminating
2)Logging :
MyProfiler allows you to log the events that occur on
your server to a text file or a MySql table. You can
set limitation on the size of the text file or the
number of rows of the table to avoid extreme
growth .When you choose the logging to a mysql table
you can use this workload as an input to the index
tuning wizard to analyze the best index structure on
your database .
3)Index tuning wizard :
The Index Tuning Wizard allows you to select and
create an optimal set of indexes and statistics for a
MySql Server database without requiring an expert
understanding of the structure of the database, the
workload, or the internals of MySQL Server.The wizard
will recommend the best mix of indexes for a database.

Download (9830 KB) Website Link to this page