The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MYSQL Slow Query log...

Discussion in 'Workarounds and Optimization' started by howzit, Aug 16, 2012.

  1. howzit

    howzit Member

    Joined:
    Feb 20, 2012
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Howzit! Free Advertising Classifieds
    cPanel Access Level:
    Website Owner
    Howzit!

    In my MYSQL Slow Query log I get the following....

    # Time: 120816 11:20:29
    # User@Host: *** @ localhost []
    # Query_time: 0 Lock_time: 0 Rows_sent: 194 Rows_examined: 388
    SELECT * FROM ads GROUP BY ads.id;

    And why is it logged as a slow query?

    Do you know of any way to log the source file (.php ) detail as well? I have a HUGE custom made system and so many files where this query might be...
     
    #1 howzit, Aug 16, 2012
    Last edited: Aug 16, 2012
Loading...

Share This Page