Hi,
On Tue, Feb 23, 2010 at 12:51 AM, Yang Zhang wrote:
> When running the query in MySQL InnoDB:
>
> $ vmstat 10
> procs ---memory-- ---swap-- -io --system--
> -cpu--
> r b swpd free buff cache si so bi bo in cs us sy id wa
> st
> 0 13 137
I've just committed a log-parsing front-end for mk-query-digest, a
tool included in Maatkit, so it can parse and analyze Postgres log
files. I encourage people to try this functionality and give feedback
by replying here, adding to
http://code.google.com/p/maatkit/issues/detail?id=535, or jumping
Thanks Tom, Depesz,
On Wed, Feb 10, 2010 at 1:15 PM, Tom Lane wrote:
> turn off log_statement and instead set
> log_min_duration_statement = 0 to log everything via duration logging.
That does the trick. Time to write more test cases.
Thanks
Baron
--
Sent via pgsql-general mailing list (pgsq
d on a
separate line. Is the sample above from a different version? Or is
there a way to get this output with different configuration? Here's
the type of output that I see in 8.3.9:
2010-02-08 15:31:50.872 EST LOG: statement: select 1;
2010-02-08 15:31:50.881 EST LOG: duration: 10.870 ms
-
Hi,
> Is there any software for postgresql like innotop for mysql ?
I am not sure. A while ago I saw a demo of pgtop, but I haven't
actually used it. I forget exactly who created it, but I think that
at least Selena Deckelmann had contributed to it.
> I would like to monitor postgresql with Ca
elmann, Robert Treat, Robert Hodges, and David Fetter.
I hope to see you there.
Baron
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
--
Sent via pgsql-general mailing list (pgsql-general@
I am jumping into this thread late, and maybe this has already been
stated clearly, but from my experience benchmarking, LVM does *not*
lie about fsync() on the servers I've configured. An fsync() goes to
the physical device. You can see it clearly by setting the write
cache on the RAID controlle