Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1

Thread: slow_log

  1. #1
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,958
    Thanks
    120
    Thanked 76 Times in 76 Posts

    slow_log

    So I putted stuff into mycnf, so that slow queries are logging into
    mysql.slow_log table. Time set >=1 sec.

    Let me tell you nothing pops into that table. Checked with setting 0 sec, and that works fine, all kind of things are flying into that table, all queries measures 0,00000.

    The prob:
    http://agrozoo.net/jsp/Galery.jsp
    click refresh a couple of times to get idea.

    As you see at the bottom of page, the server side load time is as it is. If I remove all html & jsp processing & hence images load and let only display the timing, the server side processing time is basicaly the same !.

    So I guess it is the db it is slowing things down, despite, nothing gets into slow log.

    Any ideas ?

    EDIT: same amount of images, another sql, like 10x faster: http://agrozoo.net/jsp/Galery.jsp?p1...||||en&p100=18

    Must be db thing. How to find what is the prob ?
    Last edited by BubikolRamios; 06-11-2011 at 04:36 AM.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search


 

Posting Permissions

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