| Subject | Re: [firebird-support] Which DB is using so much processor time? |
|---|---|
| Author | Milan Babuskov |
| Post date | 2004-06-23T07:59:05Z |
Ed Dressel wrote:
On SuperServer it's hard to tell since a single process is running
everything, so if one client loads the server with some heavy query, all
others slow down significantly. With Classic it is easier.
If you use Classic on Linux, you can find the root of the problem. First
find the process id by loking at output of "ps ax" and "top" commands.
And then just use "lsof" command to see which database file is process
using.
--
Milan Babuskov
http://fbexport.sourceforge.net
> On a server with multiple DB's, is there anyway of knowing which FBSuperServer? Classic? Windows? Linux?
> DB is pegging the processor for long periods of time? If not, is this
> a planned feature for 2?
On SuperServer it's hard to tell since a single process is running
everything, so if one client loads the server with some heavy query, all
others slow down significantly. With Classic it is easier.
If you use Classic on Linux, you can find the root of the problem. First
find the process id by loking at output of "ps ax" and "top" commands.
And then just use "lsof" command to see which database file is process
using.
--
Milan Babuskov
http://fbexport.sourceforge.net