Search Postgresql Archives

Re: Drupal and PostgreSQL - performance issues?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hmm, those are interesting numbers. Did you use a real, logged in, drupal session ID (anonymous users also get one, which still gives them cached pages).

They are in the form of "SESS6df8919ff2bffc5de8bcf0ad65f9dc0f=59f68e60a120de47c2cb5c98b010ffff"

Note how the thoughput stays in the 30-ish range from 100 to 400, although the response time climbs steeply. That might indicate that your Apache configuration is the main roadblock here, since that indicates that clients are waiting for a free Apache process to handle their request (I suppose you're using MPM_PREFORK)…
--
Kind regards,

Mikkel Høgh <mikkel@xxxxxxxxx>

On 14/10/2008, at 18.44, Ivan Sergio Borgonovo wrote:

BTW I hope someone may find good use of this:

2xXeon HT CPU 3.20GHz (not dual core), 4Gb RAM, RAID 5 SCSI
* absolutely not tuned Apache
* absolutely not tuned Drupal with little content, some blocks and
some google adds
(just CSS aggregation and caching enabled)
* lightly tuned PostgreSQL 8.1
shared_buffers = 3500
work_mem = 32768
checkpoint_segments = 10
effective_cache_size = 15000
random_page_cost = 3
default_statistics_target = 30

siege -H "Cookie: drupalsessid" -c1 "localhost/d1"
-b -t30s

-c 1
Transactions:                    485 hits
Availability:                 100.00 %
Elapsed time:                  29.95 secs
Data transferred:               5.33 MB
Response time:                  0.06 secs
Transaction rate:              16.19 trans/sec
Throughput:                     0.18 MB/sec
Concurrency:                    1.00
Successful transactions:         485
Failed transactions:               0
Longest transaction:            0.13
Shortest transaction:           0.06

-c 5
Transactions:                   1017 hits
Availability:                 100.00 %
Elapsed time:                  29.61 secs
Data transferred:              11.29 MB
Response time:                  0.15 secs
Transaction rate:              34.35 trans/sec
Throughput:                     0.38 MB/sec
Concurrency:                    4.98
Successful transactions:        1017
Failed transactions:               0
Longest transaction:            0.24
Shortest transaction:           0.08

-c 20
Transactions:                    999 hits
Availability:                 100.00 %
Elapsed time:                  30.11 secs
Data transferred:              11.08 MB
Response time:                  0.60 secs
Transaction rate:              33.18 trans/sec
Throughput:                     0.37 MB/sec
Concurrency:                   19.75
Successful transactions:         999
Failed transactions:               0
Longest transaction:            1.21
Shortest transaction:           0.10

-c 100
Transactions:                   1085 hits
Availability:                 100.00 %
Elapsed time:                  29.97 secs
Data transferred:               9.61 MB
Response time:                  2.54 secs
Transaction rate:              36.20 trans/sec
Throughput:                     0.32 MB/sec
Concurrency:                   91.97
Successful transactions:         911
Failed transactions:               0
Longest transaction:           12.41
Shortest transaction:           0.07

-c 200
Transactions:                   1116 hits
Availability:                 100.00 %
Elapsed time:                  30.02 secs
Data transferred:               9.10 MB
Response time:                  4.85 secs
Transaction rate:              37.18 trans/sec
Throughput:                     0.30 MB/sec
Concurrency:                  180.43
Successful transactions:         852
Failed transactions:               0
Longest transaction:           15.85
Shortest transaction:           0.25

-c 400
Transactions:                   1133 hits
Availability:                 100.00 %
Elapsed time:                  29.76 secs
Data transferred:               8.51 MB
Response time:                  6.98 secs
Transaction rate:              38.07 trans/sec
Throughput:                     0.29 MB/sec
Concurrency:                  265.85
Successful transactions:         736
Failed transactions:               0
Longest transaction:           28.55
Shortest transaction:           0.00

<<attachment: smime.p7s>>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux