Originally posted by Imago up 27 days, wow! Would you please share your Apache settings.
Imago that 27 is the server up time (Its a new server never rebooted it till date), I restarted apache at the same time I did Mysql about 9 days back.
Allwin A 85% of my pages are dynamic in nature using MySQL but all the coding is done by me, I am fairly good in PHP so all the PHP code is optimized, most of the dynamic pages size is between 16-22 KB in size.
Originally posted by HQHost I think that even more than half a million. I think ten times more pageviews than you have now...
Wow half a million will be more than enough for me, I just have one more question, I have seen webhost / webmasters overloding there servers load to 2-4% CPU usage for a P4/Xeon machines and it works fine, what do you thing is the maximum load a Celeron processors could take without performance issues.
Your cache-stats are good, but i think you should do something about the key-writes/ratio
Anyway, if you really wanna know, you can always do a benchmark test like httperf on the index of your site. I did one for fun before I actually let my server go live. It should be able to take 200 hits per second without the server crumbling (mysql and apache will not respond much more though)
Server traffic: These tables show the network traffic statistics of this MySQL server since its startup.
Traffic ø per hour
Received 4,084 MB 25,182 KB
Sent 3,749 MB 23,114 KB
Total 7,833 MB 48,296 KB
Connections ø per hour %
Failed attempts 17 0.10 0.00 %
Aborted 81,158 488.66 7.70 %
Total 1,054,438 6,348.82 100.00 %
Query statistics: Since its startup, 14,656,327 queries have been sent to the server.
Total ø per hour ø per minute ø per second
14,656,327 88,246.38 1,470.77 24.51