From: | Rauan Maemirov <rauan(at)maemirov(dot)com> |
---|---|
To: | Alan McKay <alan(dot)mckay(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: what server stats to track / monitor ? |
Date: | 2009-06-12 20:40:10 |
Message-ID: | c78bcec0906121340r13764aedj9a4ea17e2cec01d4@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi Alan. For simple needs you can use Staplr, it's very easy to configure.
There's also one - zabbix, pretty much.
2009/6/13 Alan McKay:
> Hey folks,
>
> I'm new to performance monitoring and tuning of PG/Linux (have a fair
> bit of experience in Windows, though those skills were last used about
> 5 years ago)
>
> I finally have Munin set up in my production environment, and my
> goodness it tracks a whole whack of stuff by default!
>
> I want to turn off the graphing of unimportant data, to unclutter the
> graphs and focus on what's important.
>
> So, from the perspective of both Linux and PG, is there canonical list
> of "here are the most important X things to track" ?
>
> On the PG side I currently have 1 graph for # connections, another for
> DB size, and another for TPS. Then there are a few more graphs that
> are really cluttered up, each with 8 or 9 things on them.
>
> On the Linux side, I clearly want to track HD usage, CPU, memory. But
> not sure what aspects of each. There is also a default Munin graph
> for IO Stat - not sure what I am looking for there (I know what it
> does of course, just not sure what to look for in the numbers)
>
> I know some of this stuff was mentioned at PG Con so now I start going
> back through all my notes and the videos. Already been reviewing.
>
> If there is not already a wiki page for this I'll write one. I see
> this is a good general jump off point :
>
> http://wiki.postgresql.org/wiki/Performance_Optimization
>
> But jumping off from there (and searching on "Performance") does not
> come up with anything like what I am talking about.
>
> Is there some good Linux performance monitoring and tuning reading
> that you can recommend?
>
> thanks,
> -Alan
>
> --
> “Mother Nature doesn’t do bailouts.”
> - Glenn Prickett
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alan McKay | 2009-06-12 20:40:12 | Re: what server stats to track / monitor ? |
Previous Message | Joshua Tolley | 2009-06-12 20:34:41 | Re: what server stats to track / monitor ? |