[Pgpool-hackers] show pool_status like...

[Jehan-Guillaume (ioguix) de Rorthais]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 13/09/2011 07:42, Tatsuo Ishii wrote:
> Hi,

Hello Tatsuo,

> While I took a look at MySQL manual (mainly for checking query cache
> functionality), I noticed that MySQL has following syntx:
> 
> show .... like 'foo%';
> 
> I think this is usefull for "show pool_status" command since it has
> lengthy output now.
> 
> Usage of show pool_status and like will be something like:
> 
> show pool_status like 'client_idle%' will only show the status of
> client_idle_limit and client_idle_limit_in_recovery.

Well, note that this is one of the (many) advantages of pgpool_adm:
having pcp commands as SQL functions.

So we can do :

  SELECT * FROM pcp_pool_status(...) WHERE ...;

> Comments?

- -- 
Jehan-Guillaume (ioguix) de Rorthais
http://www.dalibo.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk5u+VkACgkQXu9L1HbaT6KtzACeNQN/EZaqxJ5dW3Pgwpc60s1e
MhsAoLKR/2wOUnq8YEWcY2ZeR0Sgpv+y
=Lts2
-----END PGP SIGNATURE-----