I looked around and did not find an existing answer to this question.
Information
My site is based on Ajax, Apache, Mysql and PHP.
I already created my site, and it works well, however, as soon as too many users start connecting (when receiving about 200 + requests per second), the server works very poorly.
This site is very dependent on ajax. The main page of the site executes an ajax request every second, so if 100 people are online, I get at least 100 requests per second.
These ajax requests trigger server-side mysql requests. These queries return small data sets. The returned datasets will change very often, so I assume that caching will be inefficient.
Questions
1) What tuning methods will best help me increase the maximum number of requests per second? This applies to Ajax, Mysql, PHP, and Apache.
2) . For Apache, do I want persistent connections (KeepAlive directive) to be "On" or "Off"? As far as I understand, Off is useful if you expect many users, but On is useful for ajax, and I need both of these things.
3) . When I test server performance when serving a simple, short html page without ajax (and including only one junior mysql request), it still works very poorly when this page receives more than 200 requests per second. I assume this should be due to apache server configuration / resources. What options should I improve?
Thanks for any help!