Our team have developed a web browser game, our servers are using nginx and php-fpm to host the website. the game consist of two parts an api and the game itself. both applications reside on its own server. during load testing I found out that both applications spawn many php-fpm threads making the cpu usage of both servers reach 100%, during the analysis we have found out that these cpu hugs are due to complex sql queries. What can we do to speed up our servers response time?
Asked
Active
Viewed 59 times
0
-
1Fix the queries? – Michael Hampton Feb 12 '16 at 07:26
-
queries are all using indexes and already optimized, but the profiler still shows that the queries take time – Dominick Navarro Feb 12 '16 at 07:27
-
There's not nearly enough information here to begin to answer. – Michael Hampton Feb 12 '16 at 07:30
-
Suggest you post on Stack Exchange DBA site for help with your database issues, it's a specialized topic. SF is more for server stuff than DBA stuff. http://dba.stackexchange.com/ – Tim Feb 13 '16 at 05:31