Re: how could select id=xx so slow?

Craig Ringer <ringerc@xxxxxxxxxxxxx> · Thu, 12 Jul 2012 10:20:26 +0800



    On 07/12/2012 08:47 AM, Yan Chunlu
      wrote:

    
      Really sorry for the lack of information
    I shouldn't have grumped like that either, sorry about that.

    
    I didn't mention the connections  number because I
      don't think my app is that busy, and the large number connections
      was caused by slow queries.

    
    Yep - assumptions are a killer like that.

    
    Now you know to watch your system load with iostat, vmstat, top, etc
    and to monitor your overall load.

    
    --

    Craig Ringer