En hel del av mina problem tycks ha berott på att jag inte hade optimerat MySQL för användning med Drupal. När jag nu har gjort detta så kan jag plötsligt köra -n 1000 -c 100:
Kod:
Server Software: Apache/2.2.8
Server Hostname: domain
Server Port: 80
Document Path: /
Document Length: 12855 bytes
Concurrency Level: 100
Time taken for tests: 48.9451 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Total transferred: 13416000 bytes
HTML transferred: 12855000 bytes
Requests per second: 20.83 [#/sec] (mean)
Time per request: 4800.945 [ms] (mean)
Time per request: 48.009 [ms] (mean, across all concurrent requests)
Transfer rate: 272.88 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 9 27.1 0 97
Processing: 324 4574 1935.1 4647 42007
Waiting: 163 4373 779.1 4553 5111
Total: 364 4583 1928.9 4648 42095
Percentage of the requests served within a certain time (ms)
50% 4648
66% 4684
75% 4716
80% 4741
90% 4868
95% 4975
98% 5027
99% 5118
100% 42095 (longest request)
Servern går alltså inte ner sig även om det är segt jämfört med shared hostingkontot. Kör jag mer rimliga -n 100, -c 10 så får jag nu följande:
Kod:
Server Software: Apache/2.2.8
Server Hostname: domain
Server Port: 80
Document Path: /
Document Length: 12855 bytes
Concurrency Level: 10
Time taken for tests: 4.645497 seconds
Complete requests: 100
Failed requests: 0
Write errors: 0
Total transferred: 1341600 bytes
HTML transferred: 1285500 bytes
Requests per second: 21.53 [#/sec] (mean)
Time per request: 464.550 [ms] (mean)
Time per request: 46.455 [ms] (mean, across all concurrent requests)
Transfer rate: 281.99 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 0.0 0 0
Processing: 44 451 1058.5 46 4521
Waiting: 39 445 1058.5 40 4515
Total: 44 451 1058.5 46 4521
Percentage of the requests served within a certain time (ms)
50% 46
66% 51
75% 137
80% 170
90% 1564
95% 3171
98% 4482
99% 4521
100% 4521 (longest request)
Helt andra siffror jämfört med tidigare!
Jag tolkar det här som att det finns ytterligare behov av optimering mellan Drupal och MySQL, och att det primärt inte handlar om att 512MB RAM inte skulle räcka.