Pls help me

[nilandanj]

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

[lark]

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

[Jeff North]

On Fri, 10 Nov 2006 04:49:26 -0500, in mailing.database.mysql
nilandanj <ni**************@no-mx.forums.yourdomain.com.au>
<ni**************@no-mx.forums.yourdomain.com.auwrote:

>|
| 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
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------