Hi Mike,
Thanks for the details. Yes, besides another mysql server running on
the same server, there is also an homegrown application that frequent
read/write the file system.
The postgres shared cache is at 4G, is that too big?
Thanks
Sean
On Tue, Jun 30, 2009 at 1:23 PM, Mike Ivanov wrote:
>
: 8193140k total, 224916k used, 7968224k free, 30829456k cached
Didn't really see the pattern, typical the cpu load is only about 40%
On Mon, Jun 29, 2009 at 7:26 PM, Mike Ivanov wrote:
> Hi Sean,
>
> Sean Ma wrote:
>>
>> One months ago, this type of slow query happened a
I have a table about 50 million rows. There are a few writers to pump
data into the table at the rate of 4 row/hours. Most the time, the
SELECT is less than 100 ms. However sometime it is very slow, from 30
seconds to 500 seconds. The database is vacuum analyze regularly.
One months ago, this
