>>>>> "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!
You can use the following procedure to test a single query:
mysql> SHOW VARIABLES;
mysql> EXPLAIN SELECT ...
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>
|• Test Tools!||Sam||14 May|
| • Test Tools!||Michael Widenius||14 May|