Hi,

My site is on a *nix machine but I develop the site on window.
Are there any tools that would allow me to analyze my queries?

I am trying to nail down my slow queries but I cannot really find
anything that would help.
A tool that looks at the queries and give some suggestions would be
ideal.

Thanks

FFMG


--

'webmaster forum' (http://www.httppoint.com) | 'webmaster Directory'
(http://www.webhostshunter.com/) | 'Recreation Vehicle insurance'
(http://www.insurance-owl.com/other/car_rec.php)
'Free URL redirection service' (http://urlkick.com/)
------------------------------------------------------------------------
FFMG's Profile: http://www.httppoint.com/member.php?userid=580
View this thread: http://www.httppoint.com/showthread.php?t=17770

Message Posted via the webmaster forum http://www.httppoint.com, (Ad revenue sharing).

FFMG wrote:
> Hi,
>
> My site is on a *nix machine but I develop the site on window.
> Are there any tools that would allow me to analyze my queries?
>
> I am trying to nail down my slow queries but I cannot really find
> anything that would help.
> A tool that looks at the queries and give some suggestions would be
> ideal.
>
> Thanks
>
> FFMG
>
>
on the server, you can turn on the slow auery log. this will log any
queries that will take more than a specific time to execute!

read up on it, on mysql's web site.