Want to know how many queries a script is using

Discussion in 'PHP' started by egdcltd, Apr 18, 2008.

  1. #1
    Is there any way of finding out how many MySQL queries a script is running? The script is, unfortunately, encrypted, which will probably cause problems.
     
    egdcltd, Apr 18, 2008 IP
  2. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #2
    from phpmyadmin you can watch the load on database server and all stat available over there

    Unfortunately on shared hosting some servers donot allow that

    Regards

    Alex
     
    kmap, Apr 18, 2008 IP
  3. egdcltd

    egdcltd Peon

    Messages:
    691
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I've got a dedicated server, so no problem there, but where should I look in phpMyAdmin? On the launch page, or within the database I want to check? And what should I look for please?
     
    egdcltd, Apr 18, 2008 IP
  4. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #4
    in phpmyadmin look for "status" on the launch page.Reset all log .

    then open the page on which u have doubt.

    then read from the status page number of queries executed
     
    kmap, Apr 18, 2008 IP