Hi,
On Tue, Feb 23, 2010 at 12:51 AM, Yang Zhang yanghates...@gmail.com 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
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
. 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
--
Baron Schwartz
Percona
Thanks Tom, Depesz,
On Wed, Feb 10, 2010 at 1:15 PM, Tom Lane t...@sss.pgh.pa.us 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
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
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@postgresql.org
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