[Pgpool-hackers] Admin interface, statistics views, etc

[Tatsuo Ishii]

> Le 03/08/2010 13:29, Guillaume Lelarge a écrit :
> > Le 03/08/2010 12:23, Tatsuo Ishii a écrit :
> >>> Le 03/08/2010 03:48, Tatsuo Ishii a écrit :
> >>>>>>> AFAICT, it works really good. We still miss pgsql_pid. And should I add
> >>>>>>> some other reports? what do other people need?
> >>>>>>>
> >>>>>>
> >>>>>> No comments on this patch? meaning I should commit it or not?
> >>>>>
> >>>>> I was waiting for you add pgsql_pid. Have you done it?
> >>>>
> >>>> I have added new function:
> >>>> /*
> >>>>  * Return pointer to i th child, j th connection pool and k th backend
> >>>>  * of connection info on shmem.
> >>>>  */
> >>>> ConnectionInfo *pool_coninfo(int child, int connection_pool, int backend)
> >>>>
> >>>> I hope this will make your implementation regarding pgsql_pid easier.
> >>>> For example, pool_coninfo(10, 0, 1) will return pointer to
> >>>> ConnectionInfo corresponds to 1th backend pid which is in 0th
> >>>> connection pool in 10th pgpool child.
> >>>
> >>> Sorry for not answering sooner. I thought you were working on adding
> >>> pgsql_pid. There was a little misunderstanding :)
> >>
> >> Oh, I thought I woould work on pcp command, you would work on show
> >> command. 
> >>
> > 
> > No problem :)
> > 
> > I'll work on it ASAP.
> > 
> 
> With your last commits, it makes it quite easy to do. Here is my new
> patch.

Thanks. I will look into this.

> I still have an issue and perhaps you have an idea on how to
> resolve it. Is there a way to know which connection is the active one in
> a pool?

Good question:-) I never thought about it. Let me check...
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp