[pgpool-general: 2568] Re: measuring balancing success

[Granthana Biswas]

Jaime,

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.

Regards,
Granthana


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>
> wrote:
> > 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
> get
> > the ratio from that. Logging in database should be set for all the
> queries.
> >
>
> 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...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140212/7d1faa8c/attachment.html>