Thread: show pool_status like...

Hi,

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.

Comments?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

Tatsuo Ishii <ishii@sraoss.co.jp> writes:
> 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.

> Comments?

I think you need to rethink how you've got pool_status defined.
The above kluge isn't going to play nicely at all with the pg_settings
view, for example.
        regards, tom lane

> Tatsuo Ishii <ishii@sraoss.co.jp> writes:
>> 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.
> 
>> Comments?
> 
> I think you need to rethink how you've got pool_status defined.
> The above kluge isn't going to play nicely at all with the pg_settings
> view, for example.

Sorry, I accidently posted to pgsql-hackers, not pgpool-hackers. This
proposal was not for PostgreSQL and please forget this.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp