Thread: Any monitor programs?

Are there any monitor programs for administrator to find out what
operations are in progress and possibly killing deadlocking queries?

Regards,

Kari Lempiäinen

Kari Lempiainen writes:

> Are there any monitor programs for administrator to find out what
> operations are in progress

`ps' should work on many systems.

> and possibly killing deadlocking queries?

Truly "deadlocked" queries kill themselves, btw.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

On Sun, 4 Jun 2000 03:46:46 +0200 (CEST), Peter wrote:

>Kari Lempiainen writes:
>
>> Are there any monitor programs for administrator to find out what
>> operations are in progress
>
>`ps' should work on many systems.
>

I know that. I mean to find out what is going on inside the database.
What queries are executing? What processes have locks on what tables?


Kari
--
Kari Lempiainen
kari@funky.pp.fi - PGP key ID: A7377049
http://www.urlstarter.com/
The solution for Internet link database