Hi all,

I have some old retired server in company, they are HP DL360 G6 with 32G RAM plus 2x Xeon L5520

I make Hyper-V on it with Server 2012 R2 for do some test compare with our LIVE Shop hosting on Data Center other than my company server room

I full FTP download the live shop and Full backup the MySQL.

Then on this Hyper-V build a CentOS 6.5 on it with give it two vCPU, 2GB vRAM, 127GB HDD etc. Then restore the web site on it.

Okay.

Our Shop have over 1000 products, 300000 orders record in MySQL orders table....


Running the Apache AB with this...
ab -k -c 1000 -n 1000 http://www.yoursite.com/store/index.php

It will error
apr_socket_recv connection refused (111)
or
apr_socket_recv: Connection reset by peer (104)


Okay, I thinking 1000 too many
Then try as low as 60
ab -k -c 60 -n 60 http://www.yoursite.com/store/index.php
Result
This is ApacheBench, Version 2.3 <$Revision: 655654 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking www.yoursite.com (be patient).....done


Server Software: Apache/2.2.15
Server Hostname: www.yoursite.com
Server Port: 80

Document Path: /store/index.php
Document Length: 174959 bytes

Concurrency Level: 60
Time taken for tests: 39.918 seconds
Complete requests: 60
Failed requests: 59
(Connect: 0, Receive: 0, Length: 59, Exceptions: 0)
Write errors: 0
Total transferred: 10459142 bytes
HTML transferred: 10434722 bytes
Requests per second: 1.50 [#/sec] (mean)
Time per request: 39917.792 [ms] (mean)
Time per request: 665.297 [ms] (mean, across all concurrent requests)
Transfer rate: 255.88 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 3 56 20.5 68 68
Processing: 27890 35249 5271.5 38686 39848
Waiting: 27645 35070 5333.6 38484 39838
Total: 27901 35305 5287.5 38754 39916

Percentage of the requests served within a certain time (ms)
50% 38754
66% 39637
75% 39697
80% 39735
90% 39895
95% 39915
98% 39915
99% 39916
100% 39916 (longest request)

It have error on requests, Why? And the time look like too bad right? For a Site with over 300000 Order Record in orders table inside MySQL.


Any suggestion? Any how many concurrent user your web site general? And do you have try using Apache AB testing, then also connect to your site home page (It will immediately come real slowly response.. or as bas as show the MySQL error page say the site is down.)

Hope any great suggestion on tune the server ..

Thank you of your time and reply.