[pgpool-general: 2568] Re: measuring balancing success
granthana at zedo.com
Wed Feb 12 14:46:12 JST 2014
For saving space you can use syslog and keep the logs on different machine.
Create the log hourly basis like log-00, log-01 and gzip them after being
written to. That will save space.
On Wed, Feb 12, 2014 at 4:43 AM, Jaime Casanova <jaime at 2ndquadrant.com>wrote:
> On Tue, Feb 11, 2014 at 1:41 AM, Granthana Biswas <granthana at zedo.com>
> > Jaime,
> > You can setup Pgbadger for master and slave database which will show the
> > number of SELECT and DML queries being fired for a day on both. You can
> > the ratio from that. Logging in database should be set for all the
> yeah i thought on that the bad thing is that it could take a lot of
> space because of logs... the other option i was thinking was using
> pg_stat_statements and take snapshots every often... it's less
> accurate but maybe it use less space too.
> i think that is an important info pgpool should capture and display easily
> Jaime Casanova www.2ndQuadrant.com
> Professional PostgreSQL: Soporte 24x7 y capacitación
> Phone: +593 4 5107566 Cell: +593 987171157
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general