Announcement

Announcement Module
Collapse
No announcement yet.

How to trace mysql server

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to trace mysql server

    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

  • #2
    Check this page :

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

    I recommend you use the mysqldumpslow command to process the log. It can sort by many parameters.

    Comment

    Working...
    X