Results 1 to 3 of 3

Thread: cost of query

  1. #1
    Join Date
    Jun 2007
    Posts
    197

    Smile Unanswered: cost of query

    how can we check the time taken by any query to execute in mysql

  2. #2
    Join Date
    May 2007
    Posts
    8
    Hi,

    phpMyAdmin show query execution time in sec's when you run any query on it.
    for e.g Showing rows 0 - 16 (17 total, Query took 0.0008 sec)

  3. #3
    Join Date
    Jun 2007
    Posts
    197

    Smile

    Quote Originally Posted by swapnilclarion
    Hi,

    phpMyAdmin show query execution time in sec's when you run any query on it.
    for e.g Showing rows 0 - 16 (17 total, Query took 0.0008 sec)

    set profiling command doesnot support mysql 5.0.18
    is there any command like that

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •