Search through our group's posts (events, discussions, jobs, etc.) and their comments here. Results are displayed in order of post date. Use the pager below to browse results.
Installing Drupal with PHP-FPM
Running into all sort of problems after trying to configure Drupal 7 to run on PHP-FPM on CentOS 6.2 Apache 2.2 this week.
I was reviewing @kbahey 2bits.com excellent article on configuring Drupal to run with fcgid and I was wondering if we could use that as a starting point to explore a PHP-FPM deployment.
http://2bits.com/articles/apache-fcgid-acceptable-performance-and-better...
I am getting a series of timeout/server 500 errors in my httpd/logs/error_log such as these after install:
Read moreRunning Drupal as daemon service
Introduction
PHP Frameworks are becoming more and more complex, specially now that almost all of them are fully object oriented. In serious applications huge amount of code needs to be interpreted and loaded into the memory for every request, it's a needles waste of huge amount of resources.
But what if we could serve requests not by using traditional request/response method but by using sockets and asynchronous calls?
Understanding and optimising a slow mysql query (views)
I have a views query that is my number 1 slow query. I have been trying to understand why it's slow and what to do about it, but I am struggling. So far I think that it's slow because it's using temporary table and a filesort, as shown in the 'Explain'. When I remove the 2nd "ORDER BY" statement (node_data_field_opportunity_closing_date_field_opportunity_closing_date_value ASC), no temporary table is used the query time is significantly reduced.
Is there a way to keep results ordered without generating a temporary table? Any other tips on this query would be appreciated :-)
Read moreNeed advice for faster Drupal website
Hello everyone.
I have a website for ads.
This is the url: www.4sport.bg
It's hosted on Managed VPS with 4gb ram.
I'm not caching it with the standard procedure from here: admin/config/development/performance, because the website has registered users that will be able to create an ad, update their ads, view their profiles etc, it's very dynamic so I needed something better to cache.
The website is not fast as it should. It usually loads more than 1300ms.
I'm using PHP APC and you can see it from here: www.4sport.bg/apc.php
Read moreScaling a drupal site to handle 1000 authenticated reqests per second
We are planning to make a Learning Management System with drupal.We have created a site which can run a single course at a time.
There are 84 modules installed in the site.
Our aim is to handle 1000 authenticated requests per second.
(This can be viewing the site or adding content to the site)
Our server details are as follows:
(this is a vm on one server)
Memory : 16GB
Processor: 8 core
OS: Ubuntu
Webserver : Ngnx
We have php-fpm with maria db as database server
We have installed APC and Memcache in the site.
Read morevarnish purge cache all the time
I'm constantly seeing following line in my syslog'
varnishd[2826]: CLI telnet 192.168.XX.XX:60069 172.16.XX.XX:6082 Rd purge req.http.host ~ XXX.XXX.XXX && req.url ~ "/"and it doesn't seems like someone does it manually all the time either...
I'm able to confirmed that cache is actually is purging at every request and i'm on clean slate (in terms of cache) after purge is done.
how would one troubleshoot something like that?
Read moreHigh cpu usage in webserver
We have separate machines for database server and web server (each with 8GB RAM and 4 cores)
The user CPU% of web server is around 60-70% (when you run a jmeter test that login 100 users)
In database server its less than 5%.
We have Apache with php5-fpm.By top command we can see that each php-fpm process is taking more than 20% of CPU
Memcache and Apc are on web server itself.Why is the CPU usage this high ?
Read morePHPNG Being Tested In PHP 6
Just noticed this interesting post about Facebook's PHPNG being tested in the PHP6 branch. Of course it's really early, so there is no way of knowing if it will actually be included in a future release of PHP, but it is something to keep an eye on:
http://www.phpclasses.org/blog/post/234-PHPNG-Dramatic-Speedup-Features-...
Read moreDrupal 6 Site Offline Template
... every once in a while users are getting "Site Off-Line" message when trying to access Drupal6 (Pressflow), so I start looking into following document to modifiy template and possibly provide me with a reasoning on why Drupal keeps doing that..
Theming the Drupal maintenance page | Drupal.org
What should be included into new template page? I was thinking at least this one:
PHP: mysqli::$connect_error - Manual
but what else would be useful in order to troubleshoot site offline??
Read moreMinimizing Bootstrapping.
Hi Everyone!
I've written a PHP page that sits inside my Drupal install and is used for split second traffic processing and directing. Pending certain conditions (carried as POST data in the url) the script progressively bootstraps Drupal.
For instance we first look to see if we can direct the user to a cached page. If not, we bootstrap to DATABASE and run a couple of simple queries to see if we need to direct them to somewhere else.
Read more


