Databases
StackOverflow2013
Postsdbo
POSymfony2 website with +100 users = 100% CPU charge
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSymfony2 website with +100 users = 100% CPU charge
    primarykey
    data
    text
    <p>I have a problem I can't solved with my server. I may miss a config somewhere, but I searched and find nothing fine.</p> <p>Server hardware : Intel Atom N2800 2 cores, 4 threads (<a href="http://ark.intel.com/products/58917/" rel="nofollow">http://ark.intel.com/products/58917/</a>) 4Gb RAM</p> <p>It's running under Debian7 with NGinx, PHP5 FPM and MySQL.</p> <p>There is only one website running. Average 50 visitors at the same time, peak up to 140 visitors.</p> <p>This is what happen when a peak time :</p> <pre><code>top - 23:01:41 up 80 days, 8:40, 1 user, load average: 19,78, 19,52, 19,37 Tasks: 166 total, 22 running, 144 sleeping, 0 stopped, 0 zombie %Cpu(s): 90,6 us, 9,1 sy, 0,0 ni, 0,0 id, 0,0 wa, 0,0 hi, 0,3 si, 0,0 st KiB Mem: 4020300 total, 3232164 used, 788136 free, 362764 buffers KiB Swap: 525308 total, 121404 used, 403904 free, 1191508 cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 32295 www-data 20 0 247m 37m 6456 R 19,5 1,0 4:02.15 php5-fpm 32469 www-data 20 0 251m 40m 6592 R 19,5 1,0 3:30.46 php5-fpm 32689 www-data 20 0 243m 32m 6816 R 19,2 0,8 2:56.03 php5-fpm 32692 www-data 20 0 251m 41m 6564 R 19,2 1,0 2:57.84 php5-fpm 1115 www-data 20 0 251m 40m 6428 R 18,9 1,0 0:54.01 php5-fpm 1249 www-data 20 0 251m 40m 6356 R 18,9 1,0 0:42.35 php5-fpm 1251 www-data 20 0 250m 39m 6420 R 18,9 1,0 0:37.36 php5-fpm 31314 www-data 20 0 251m 40m 6440 R 18,9 1,0 6:52.49 php5-fpm 32296 www-data 20 0 251m 40m 6560 R 18,9 1,0 4:03.63 php5-fpm 32410 www-data 20 0 251m 40m 6708 R 18,9 1,0 3:53.65 php5-fpm 32468 www-data 20 0 247m 36m 6720 R 18,9 0,9 3:27.14 php5-fpm 32471 www-data 20 0 251m 40m 6472 R 18,9 1,0 3:33.24 php5-fpm 32691 www-data 20 0 251m 40m 6584 R 18,9 1,0 3:03.90 php5-fpm 32294 www-data 20 0 251m 40m 6452 R 18,5 1,0 4:18.55 php5-fpm 32297 www-data 20 0 251m 40m 6456 R 18,5 1,0 4:07.43 php5-fpm 32467 www-data 20 0 246m 35m 6456 R 18,5 0,9 3:41.64 php5-fpm 1250 www-data 20 0 241m 30m 6312 R 18,2 0,8 0:37.06 php5-fpm 32114 www-data 20 0 247m 37m 6428 R 18,2 0,9 4:38.27 php5-fpm 32470 www-data 20 0 243m 32m 6424 R 18,2 0,8 3:30.56 php5-fpm 32527 www-data 20 0 239m 28m 6428 R 18,2 0,7 3:19.96 php5-fpm 1629 root 20 0 17228 5444 1308 S 2,9 0,1 0:01.63 rkhunter 23561 mysql 20 0 488m 73m 7944 S 1,3 1,9 227:34.60 mysqld 4016 root 20 0 23740 1660 1136 R 0,7 0,0 0:00.07 top 20368 www-data 20 0 66340 4732 2116 S 0,3 0,1 10:34.08 nginx </code></pre> <p>You surely understand that I can't let it like that.</p> <p>The website is built with Symfony2. The config file of symfony is available here : <a href="http://pastebin.com/CJbea0Qf" rel="nofollow">http://pastebin.com/CJbea0Qf</a></p> <p>The phpinfo is there : <a href="https://drive.google.com/file/d/0ByNmwlJzaeKpNkNTcF9GZGNQVmM/edit?usp=sharing" rel="nofollow">https://drive.google.com/file/d/0ByNmwlJzaeKpNkNTcF9GZGNQVmM/edit?usp=sharing</a></p> <p>This is the config of Nginx for the website (I found an example and modify it a little bit) Rewrite rules are the because of old addresses. </p> <pre><code>server { listen *:80; server_name ***.fr www.***.fr; root /home/www/clients/client1/web7/web/beta/web/; rewrite ^/index.php / permanent; rewrite ^/disclaimer.php / permanent; rewrite ^/disclaimer-mobile.php / permanent; rewrite ^/news.php /news permanent; rewrite ^/contact.php /contact permanent; rewrite ^/app\.php/?(.*)$ /$1 permanent; try_files $uri @rewriteapp; location @rewriteapp { rewrite ^(.*)$ /app.php/$1 last; } # Deny all . files location ~ /\. { deny all; } # Do some static file caching location ~* \.(jpg|jpeg|gif|png|css|js|ico|xml)$ { log_not_found off; expires 1d; } location ~ ^/(app|app_dev)\.php(/|$) { fastcgi_split_path_info ^(.+\.php)(/.*)$; include fastcgi_params; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; fastcgi_index app.php; send_timeout 1800; fastcgi_read_timeout 1800; fastcgi_buffer_size 128k; fastcgi_buffers 256 16k; fastcgi_busy_buffers_size 256k; fastcgi_pass unix:/var/run/php5-fpm.sock; #fastcgi_pass 127.0.0.1:9000; } location ~ ^/(mystatus|myping)$ { access_log off; include fastcgi_params; fastcgi_pass unix:/var/run/php5-fpm.sock; } # Statics location /(bundles|media) { access_log off; expires 30d; # Font files #if ($filename ~* ^.*?\.(eot)|(ttf)|(woff)$){ # add_header Access-Control-Allow-Origin *; #} try_files $uri @rewriteapp; } } </code></pre> <p>Finally, PHP-FPM config.</p> <pre><code>pm = dynamic pm.max_children = 20 pm.start_servers = 10 pm.min_spare_servers = 8 pm.max_spare_servers = 15 pm.max_requests = 400 </code></pre> <p>I don't know if you need other data to help me solve that.</p> <p>The website is quite "light". Not a lot of user interactions, just simple pages (it's mainly a gallery), so just pages generation.</p> <p>Thanks a lot</p> <p><strong>ONE THING THAT MAY BE (or not) IMPORTANT</strong> When I reload php5-fpm, the load charge is quite calm (~2), but it amplifies with time until not going under 8.</p> <p><strong>Evolution</strong> I set up a cache with nginx fastcgi_cache parameters. Each page is cached for 5minutes. That will break up all "view" counters but I don't care as the website is clearly faster. I noticed that now, when I do a <code>service php5-fpm reload</code>, the server is going down to 1 in charge ! And it continues like that even with +100 visitors at the same time. But strangely, one time yesterday, it began to go up again, 20 on charge. I did reload php5-fpm and it all went down to 1 ! And it's working on 1 since yesterday. It seems that there some sort of trigger point that makes php-fpm going crazy !</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USLink14
    1. USLink14
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSymfony2 website with +100 users = 100% CPU charge
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSymfony2 website with +100 users = 100% CPU charge
      1. USA.L
      1. VTFavorite
    3. VO
      singulars
      1. POSymfony2 website with +100 users = 100% CPU charge
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI asume that you have the debug to off and you have the cache config. Right?
      singulars
      1. POSymfony2 website with +100 users = 100% CPU charge
      1. USmcuadros
    2. CO"You surely understand that I can't let it like that." actully no - i know many shared hosts that operate under that sort of load 24\7. Less than 100% is actully waistfull. server load is not a relal world metric, it bears no resemblance to the users experience on the site
      singulars
      1. POSymfony2 website with +100 users = 100% CPU charge
      1. This table or related slice is empty.
    3. CO140 users **simultaneously making requests** is actually a huge amount of traffic. At any given time with that load, you might have 3,000 people on your site. Depending on how that goes, you're probably looking at around 5 to 10 million unique visitors per month. Consider monetizing your site so you can use something other than an Atom CPU in a server.
      singulars
      1. POSymfony2 website with +100 users = 100% CPU charge
      1. USBrad
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload