High Performance

This group is dedicated to solutions and approaches for high traffic, high performing Drupal sites. As such, it will deal with a lot of information around the rest of a typical Drupal "stack" -- the operating system, web server, database, and PHP tweaks that combine to support the Drupal application.

This is not a support channel or a place to post bug reports.

If you think you have found a bug, use the issue queue for the appropriate project.

If you need support, see http://drupal.org/support for options.

Understanding and optimising a slow mysql query (views)

Posted by foxtrotcharlie on April 18, 2014 at 1:43pm

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 :-)

Running Drupal as daemon service

Posted by sinasalek on April 6, 2014 at 7:06pm
Last updated by sinasalek on Wed, 2015-08-12 20:15

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?

Installing Drupal with PHP-FPM

Posted by Anonymous on April 5, 2014 at 6:57pm

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:

Not caching a block

Posted by averill on April 4, 2014 at 10:06am

I am currently working on a site that is recieving over 200K visitors per month. We are using some refererer tracking code to replace the site logo depending on where the client has arrived from. The logo is contained in a block. This is implemented on almost every page.

What would the best approach to setting up some kind of cache under these circumstances?

Currently we are using some client side JS to do the logo swapping but it is proving problematic/unreliable on some browsers. IE8 in particular but we have to support IE8.

Tuning Worker MPM settings

Posted by Anonymous on March 28, 2014 at 4:07pm

I am thinking of configuring my Centos 6 server to use Worker MPM. I am pretty sure I know how to complete the install thanks to posts here in the group and elsewhere.

I have a Centos 6 LAMP server running multisite drupal. 2GB RAM. APC & memcached running, planning to install varnish, although most visitors are registered members.

My question is what should the settings look like in httpd.conf?

This is what I have at the moment. Will this even work as worker.c settings if I make the transition from prefork?

StartServers 3
MaxClients 50

Backend caching forms?

Posted by nublaii on March 26, 2014 at 5:33pm

We have a fairly normal multi-server setup: haproxy -> varnish -> drupal

We have drupal using a single memcache instance for all the caches except cache_form (we had 2 for redundancy, but since we're trying to debug this problem we're running it on a single instance).

All the urls that contain '/admin' are excluded from varnish (even though the cookie does that too, we just wanted to make sure this was not the problem).

So what happens is: a lot of the backend forms get cached.

Fixes for MySQL Deadlocks in D7

Posted by mikeytown2 on March 24, 2014 at 11:06pm

I've been working on eliminating deadlocks and speeding up the database layer of Drupal. This is what I've come up with after helping out here: http://drupal.stackexchange.com/questions/104880/drupal-7-database-selec... Not everyone can use an alternative cache backend; thus getting the best performance out of MySQL is desired. Noted that converting some cache tables to memory would only be useful for tables that don't get written to very often & low concurrently due to table level locking.

Queue Mail

Posted by tvdijck on March 19, 2014 at 1:01pm

Does anyone have any experience with Queue Mails to handle higher loads on registration?
We are running a site that has high peaks of logins and registrations (due to call to actions on television).
Logins and registration happen on both API's and the site itself and for each registration and lost password a mail is send.
Would we benefit from offloading the mails to a queue or will the benefit be marginal?

Getting started a project what should i do for future?

Posted by agiradam on March 19, 2014 at 9:15am

In summary: Getting started with a very large project you need to pay attention what? and should i start a base theme or from scratch?

i am starting a very big project with drupal 7. It will be a social media website and contain a lot of data like users info, pages, groups, live feed etc. I will do the design and css myself from scratch.

Getting started this kind of website for good performance in the future what kinds of things I need to pay attention to?

Drupal php.ini optimizations

Posted by mherchel on March 17, 2014 at 2:41pm

Hey High Performance Drupal,

I ran into this reddit thread on a php.ini optimization and figured I'd investigate this a bit more. I found a couple articles referencing this and figured I'd update Drupal.org's "Tuning PHP" documentation.

Looking at that page, it hasn't been updated since July 2009. So, my question to this group is what other tweaks, optimizations do you apply besides memory_limit, and the others listed.

Subscribe with RSS