Pls help me

Hi,
I want to solve the slow query problem...can anyone help me for this..
can anyone guide me for this that which GUI tool is helpful for me to
solve slow-query????

pls give me answer as early as possible

Nilnandan Joshi


--
nilandanj
------------------------------------------------------------ ------------
nilandanj's Profile: http://techiegroups.com/member.php?userid=708
View this thread: http://www.techiegroups.com/showthread.php?t=120546

Re: Pls help me

nilandanj wrote:
> Hi,
> I want to solve the slow query problem...can anyone help me for this..
> can anyone guide me for this that which GUI tool is helpful for me to
> solve slow-query????
>
> pls give me answer as early as possible
>
> Nilnandan Joshi
>
>
nilandanj,

the only gui tool that i know of is mysql's own administrator. once you
open this gui tool, ( and if you have slow query logging turned on in
the my.cnf), you'd be to see the queries that are slow. this tool does
not give you any suggestions or recommendations as what needs to be
done to correct the slow querry.

hope this helps

Re: Pls help me

On Fri, 10 Nov 2006 04:49:26 -0500, in mailing.database.mysql
nilandanj
wrote:

>|
>| Hi,
>| I want to solve the slow query problem...can anyone help me for this..
>| can anyone guide me for this that which GUI tool is helpful for me to
>| solve slow-query????
>|
>| pls give me answer as early as possible
>|
>| Nilnandan Joshi

Any tools will do. Just insert the command explain at the beginning of
your query. mySQL will return some information about what the query is
doing.

SELECT * FROM table WHERE a=1
to
EXPLAIN SELECT * FROM table WHERE a=1
------------------------------------------------------------ ---
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
------------------------------------------------------------ ---