Announcement

Announcement Module
Collapse
No announcement yet.

How to trace mysql server

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

  • How to trace mysql server

    #1
    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