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.
Serious performane issue because of mini-panels and multiple content types
We are working on a site whose pages are taking 17 seconds to load when it is not cached. What you see here is CCK content types like Book, Video, etc. in Block Views, which are then used in Mini Panels. These Mini Panels are joined together to create widgets. We are showing three nodes at a time for each content type - Still loading 12 different content types requires a large number of SQL queries.
Read more
Improve the load of 404 pages, page not found
When a 404 page is launched by Drupal, it needs to load all Drupal's stack.
In web sites with a lot of modules, like is my case, it means that php need load 60M ram for launch a page not found!
That is a problem if for example you have some kind of software testing your site with random urls like mcaffe.
So we made a little hack for index.php so we check previously if a page exists before load all drupal stack.
Here is the code. Someone knows a clean way for fix this problem?
/**
* @file
* The PHP page that serves all page requests on a Drupal installation.
*
How to decrease load on mysql (CAPTCHA,node counter, and xmlsitemap)?
I have read Dries Buytaert post http://buytaert.net/playing-with-new-relic-on-acquia-hosting about most time consuming operations on mysql.
I have analyzed my mysql.bin log after 2 weeks load on web-site and get the following:
- CAPTCHA - 36% of queries
Count: 696.77k (12.12%)
Query: UPDATE captcha_sessions SET token='S' WHERE csid=N
Count: 696.11k (12.11%)
Query: UPDATE captcha_sessions SET timestamp=N, solution='S' WHERE csid=N
Count: 695.75k (12.10%)
Diagnosis: Forms problem
I wonder if someone could point me in the right direction on this: I've just migrated a major UK site (600,000 users, 30,000 pages, typically 200 anonymous users accessing the site at any one time) to Drupal: http://www.ivillage.co.uk (not the US version of the site) and be prepared for possible embarrassment, this is a women's magazine website :-)
Read morePrivate file transfer is killing me
Like the title says - looking for performance expert to come up with a solution
http://drupal.org/node/1001930
regards Allan
Read more
HandlerSocket plugin for MySQL - Replacement for memcache?
interesting benchmarks
approx qps server CPU util
MySQL via SQL 105,000 %us 60% %sy 28%
memcached 420,000 %us 8% %sy 88%
MySQL via HandlerSocket 750,000 %us 45% %sy 53%http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-stor...
Verification of benchmarks
http://www.mysqlperformanceblog.com/2010/11/02/handlersocket-on-ssd/
Percona Server now both SQL and NOSQL
http://www.mysqlperformanceblog.com/2010/12/14/percona-server-now-both-s...
Easy authcache
Easy Authcache is module that makes authcache implementation easy,faster and makes it comportable with drupal community modules.
Advantages of module differs it from Authcache:
- It makes unnessary for developer to write client side callbacks for authcache module (js functions).
- Makes server side callback as hook (drupal style).
- Includes all modules.
- Handle js files and settings, needed for retrived with ajax html, on final page.
- Handle url context dependent code.
- Provide api to handle theme functions, you need, with authcache.
Page cache and fragment caching
Hi,
I'm looking for a good explanation on how to do fragment caching in Drupal. From what I understand, the "page cache" caches ALL the page, including the blocks, and not simply the "$content" variable found in page.tpl.php. Is there any documentation anywhere explaining :
- The different caches
- When they expire
- Which part of the page exactly they cover
I come from the eZ Publish world where you can basically define rules for pretty much any part of any page regarding caching and expires of caches.
Read more
Pressflow+APC+Varnish: External Cache or Drupal Default Dilemma
Hey Folks;
I've been doing a lot of performance tweaking with some of the sites I run (specifically http://latam.kaspersky.com). We have been running Varnish for some time and I recently managed to convince the powers-that-be that APC is perfectly safe and we're nuts for not running it.
Read moreCache Router: Edge condition 404s valid pages?
My company recently launched a channel on msn.com -- yes, MSN has gone (partly) Drupal (a little bit)!
This is a LAMP, PF 6.19 app with Cache Router (6.x-1.0-rc1) and multiple memcached bins, sitting behind Akamai. The home page is constructed in Panels (6.x-3.7).
We've had troubling recurrences of 404 home page responses. The symptoms look like this:
- We get monitoring alarms that the home page is serving up 404 responses.
- Apache httpd logs indicate 404s.
- Watchdog indicates nothing.
- Loading from our origin server looks good.
