Test Tools!

[Michael Widenius]

>>>>> "Sam" == Sam  <sam@stripped> writes:

Sam> I was wondering if there is a test tool for MySQL which can be used to
Sam> monitor the performance of queries e.g. how long a query took, how many
Sam> access to disk and stuffs like that!

Sam> Would like to know if any is available or have been written by someone!

Hi!

You can use the following procedure to test a single query:

mysql> SHOW VARIABLES;
mysql> EXPLAIN SELECT ...
       <output-from-EXPLAIN>
mysql> FLUSH STATUS;
mysql> SELECT ...
       <A short version of the output from SELECT,
       including the time taken to run the query>
mysql> SHOW STATUS;
       <output from SHOW STATUS>

Regards,
Monty