I'm on a CentOS 5 OS 64 bit, latest kernel and all of that.
PG version is 8.3.7, compiled as 64bit.
The memory is 8GB.
It's a 2 x Dual Core Intel 5310.
Hard disks are Raid 1, SCSI 15 rpm.
The server is running just one website. So there's Apache 2.2.11,
MySQL (for some small tasks, almost
Phoenix Kiula wrote:
I'm on a CentOS 5 OS 64 bit, latest kernel and all of that.
PG version is 8.3.7, compiled as 64bit.
The memory is 8GB.
It's a 2 x Dual Core Intel 5310.
Hard disks are Raid 1, SCSI 15 rpm.
The server is running just one website. So there's Apache 2.2.11,
MySQL (for some
Ivan Voras ivoras 'at' freebsd.org writes:
pgtop (http://pgfoundry.org/projects/pgtop/) might help you see what
is your database doing.
A simpler (but most probably less powerful) method would be to
activate stats_command_string = on in the server configuration,
then issue that query to view
Phoenix Kiula wrote:
I'm on a CentOS 5 OS 64 bit, latest kernel and all of that.
PG version is 8.3.7, compiled as 64bit.
The memory is 8GB.
It's a 2 x Dual Core Intel 5310.
Hard disks are Raid 1, SCSI 15 rpm.
The server is running just one website. So there's Apache 2.2.11,
MySQL (for some
Andy Colson wrote:
Phoenix Kiula wrote:
I'm on a CentOS 5 OS 64 bit, latest kernel and all of that.
PG version is 8.3.7, compiled as 64bit.
The memory is 8GB.
It's a 2 x Dual Core Intel 5310.
Hard disks are Raid 1, SCSI 15 rpm.
The server is running just one website. So there's Apache
On Wed, Aug 19, 2009 at 11:25 PM, Andy Colsona...@squeakycode.net wrote:
snip.
the first line of vmstat is an average since bootup. Kinda useless. run it
as: 'vmstat 4'
it will print a line every 4 seconds, which will be a summary of everything
that happened in the last 4
Kevin Grittner wrote:
Andy Colson a...@squeakycode.net wrote:
Phoenix Kiula wrote:
It's a 2 x Dual Core Intel 5310.
you have average 74% idle cpu. So your not cpu bound either?
Or one CPU is pegged and the other three are idle
-Kevin
Ahh, yeah...
Phoenix: run top again, and
On Wed, 19 Aug 2009, Phoenix Kiula wrote:
~ vmstat 4
procs ---memory-- ---swap-- -io --system-- cpu
r b swpd free buff cache si sobibo incs us sy id wa
0 2 16128 35056 62800 76974280074 1530 3 10 5 74 12
0 0
On Wed, Aug 19, 2009 at 11:37 PM, Andy Colsona...@squeakycode.net wrote:
Phoenix: run top again, and hit the '1' key. It'll show you stats for
each
cpu. Is one pegged and the others idle?
top - 10:38:53 up 29 days, 5 min, 1 user, load average: 64.99, 65.17,
65.06
Tasks: 568 total, 1
Phoenix Kiula wrote:
On Wed, Aug 19, 2009 at 11:37 PM, Andy Colsona...@squeakycode.net
mailto:a...@squeakycode.net wrote:
Phoenix: run top again, and hit the '1' key. It'll show you stats
for each
cpu. Is one pegged and the others idle?
top - 10:38:53 up 29 days, 5 min, 1 user,
Phoenix Kiula phoenix.ki...@gmail.com writes:
top - 10:38:53 up 29 days, 5 min, 1 user, load average: 64.99, 65.17,
65.06
Tasks: 568 total, 1 running, 537 sleeping, 6 stopped, 24 zombie
Cpu0 : 17.7% us, 7.7% sy, 0.0% ni, 74.0% id, 0.7% wa, 0.0% hi, 0.0% si
Cpu1 : 6.3% us, 5.6%
Phoenix Kiula phoenix.kiula 'at' gmail.com writes:
Tasks: 568 total, 1 running, 537 sleeping, 6 stopped, 24 zombie
The stopped and zombie processes look odd. Any reason for these?
--
Guillaume Cottenceau
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To
On Wed, Aug 19, 2009 at 9:40 AM, Phoenix Kiulaphoenix.ki...@gmail.com wrote:
On Wed, Aug 19, 2009 at 11:37 PM, Andy Colsona...@squeakycode.net wrote:
Phoenix: run top again, and hit the '1' key. It'll show you stats for
each
cpu. Is one pegged and the others idle?
top - 10:38:53 up 29
13 matches
Mail list logo