SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Evangelist lance_vincent's Avatar
    Join Date
    Aug 2004
    Location
    philippines
    Posts
    574
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Count number of queries

    Hi guys! i have a simple question. I wanted to run a php apge that queries mysql. After the page loaded completely, how can i know ho many number of queries has been done? is there a mysql program that will show me the details of the last queries? are these report on phpmyadmin?
    If you won't dress like the
    Victoria Secret girls,
    don't expect us to act like soap opera guys.

  2. #2
    SitePoint Addict fattyjules's Avatar
    Join Date
    Dec 2005
    Posts
    295
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MySQL has logging, but unless you have access to the server you might find that difficult. I don't believe that phpMyAdmin has any way of accessing the MySQL logs.

    If your program is issuing the queries, can't you record them yourself?

  3. #3
    SitePoint Evangelist lance_vincent's Avatar
    Join Date
    Aug 2004
    Location
    philippines
    Posts
    574
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    my goodness i wasnt notified of the reply, thanks fattyjules! yes i could make them count if i edit my code, its just that i wanted a quick graps of the numbers cause i wanted to check on the performance of one of my scripts..

    thanks again fattyjules!
    If you won't dress like the
    Victoria Secret girls,
    don't expect us to act like soap opera guys.


Bookmarks

Posting Permissions

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