Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » How to trace mysql server
How to trace mysql server [message #963] Thu, 22 March 2007 06:00 Go to next message
julian is currently offline julian
Messages: 13
Registered: March 2007
Junior Member
Hi

Is there any tool for mysql server to trace and identify the slow query(ie the query which takes more time to run) like sql profiler in sql server.


I want to identify the query in VB and optimize that. If there is any way to identify the slow query, pls reply

thanks
Report message to a moderator
Re: How to trace mysql server [message #969 is a reply to message #963 ] Thu, 22 March 2007 09:47 Go to previous message
tanj is currently offline tanj
Messages: 16
Registered: March 2007
Location: France
Junior Member
Check this page :

http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html

I recommend you use the mysqldumpslow command to process the log. It can sort by many parameters.
Report message to a moderator
Previous Topic:Slow alter table
Next Topic:Display query result from two tables...
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 00:15:31 EDT 2009

Total time taken to generate the page: 0.02223 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.