Any monitor programs?

Started by Kari Lempiainenalmost 26 years ago3 messagesgeneral

Kari Lempiainen

kari@funky.pp.fi

almost 26 years ago

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

Regards,

Kari Lempiï¿½inen

Peter Eisentraut

peter_e@gmx.net

almost 26 years ago

In reply to: Kari Lempiainen (#1)

Re: Any monitor programs?

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

Kari Lempiainen

kari@funky.pp.fi

almost 26 years ago

In reply to: Peter Eisentraut (#2)

Re: Any monitor programs?

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