Professional Web Applications Themes

Trying to track random unresponsiveness - MySQL

Ignoramus2206 wrote: > From time to time, my apache server becomes unresponsive (it often > clears up in a little while). I use MySQL inside the server for quite > a few things. I cannot squarely put the blame on MySQL server being > busy or locked up, but I want to investigate this possibility. > > Is there some way to send a query that amounts to asking SQL server > "what is it that you are doing right now". As root: SHOW PROCESSLIST Greetings Kai...

  1. #1

    Default Re: Trying to track random unresponsiveness

    Ignoramus2206 wrote:
    > From time to time, my apache server becomes unresponsive (it often
    > clears up in a little while). I use MySQL inside the server for quite
    > a few things. I cannot squarely put the blame on MySQL server being
    > busy or locked up, but I want to investigate this possibility.
    >
    > Is there some way to send a query that amounts to asking SQL server
    > "what is it that you are doing right now".
    As root:

    SHOW PROCESSLIST

    Greetings
    Kai
    Kai Ruhnau Guest

  2. #2

    Default Re: Trying to track random unresponsiveness

    Ignoramus2206 wrote:
    > On Thu, 16 Mar 2006 16:16:40 +0100, Kai Ruhnau
    > <k.ruhnautarget-systems-gmbh.de> wrote:
    >> Ignoramus2206 wrote:
    >>> From time to time, my apache server becomes unresponsive (it often
    >>> clears up in a little while). I use MySQL inside the server for quite
    >>> a few things. I cannot squarely put the blame on MySQL server being
    >>> busy or locked up, but I want to investigate this possibility.
    >>>
    >>> Is there some way to send a query that amounts to asking SQL server
    >>> "what is it that you are doing right now".
    >>
    >> As root:
    >>
    >> SHOW PROCESSLIST
    >
    > Thanks, that looks nice. I added it to the script that runs when
    > unresponsiveness is detected, will see what I find out, if anything!
    >
    > i

    Make that 'SHOW FULL PROCESSLIST' for more info.


    --
    Brian Wakem
    Email: [url]http://homepage.ntlworld.com/b.wakem/myemail.png[/url]
    Brian Wakem Guest

Similar Threads

  1. Coldfusion intermittent bursts of unresponsiveness
    By court.c in forum Coldfusion Server Administration
    Replies: 0
    Last Post: September 20th, 02:15 AM
  2. Track CF Administrator Changes
    By in forum Coldfusion Server Administration
    Replies: 0
    Last Post: August 31st, 06:37 PM
  3. Track statistics
    By lilbuckeye in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: June 23rd, 11:42 AM
  4. Using Math.random to go to random frames
    By Glen Gummess webforumsuser@macromedia.com in forum Adobe Flash, Flex & Director
    Replies: 2
    Last Post: January 23rd, 10:26 PM
  5. Random image in a random place.
    By JoshR webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: July 8th, 03:18 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139