SEO

#1 (**permalink**) 02-28-2008, 08:33 AM

Given I have the query log, are there any tools can read the log,
perform analysis or simulation, e.g. find out those slow query, query
without using index, and sort according to the number of query?

thanks.

#2 (**permalink**) 02-28-2008, 08:33 AM

There is a separate slow-query-log that you can activate. I think you
can even set the time limit for a query to be logged as slow.

You can use the EXPLAIN command to see if the appropriate indexes are
used, but the general query log does not contain info on how a query was
parsed. So no tool can see index use just by looking at the query log.

Best regards

howa wrote:
> Given I have the query log, are there any tools can read the log,
> perform analysis or simulation, e.g. find out those slow query, query
> without using index, and sort according to the number of query?
>
> thanks.
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

MySQL Profiling tools?