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.

Path_alias_cache incompatible with Pressflow external caching mode?

Posted by srjosh on October 6, 2010 at 8:31pm

pressflow and varnish work best together with external caching turned on, correct?

but External caching mode skips boot and exit hooks.

However, path_alias_cache uses hook_exit to set the paths into cache.

Are these two modes incompatible?

i.e. does varnish caching with external preclude path alias caching?

If not, any ideas what I'm missing? If so, anyone have a workaround?

Strange cookies passing Varnish

Posted by agoel@axelerant.com on October 5, 2010 at 6:52pm

I am seeing some odd cookies in a client's production environment that I cannot find anywhere in the Drupal code. Anyone seen this? What is the best approach to address this? I thought about configuring Varnish to only allow certain cookies to pass, and not pass any all other requests, but that does not seem like a good approach. Any ideas?

Help with optimization...

Posted by danmccarey on October 5, 2010 at 2:33pm

Hi everyone, I'm looking for some advice optimizing a site for authenticated users.

VPS with 2GB RAM
Pressflow 6.19
80 modules (including OG, Views, CCK & GMap)
3,500 nodes
Averaging 115,000 page views per month
MySQL using InnoDB tables
Memcache (84% hit rate)
APC (set to 64 M)

MySQL setup is:
key_buffer = 32M sort_buffer_size = 16M read_buffer_size = 16M read_rnd_buffer_size = 16M myisam_sort_buffer_size = 16M query_cache_size = 32M innodb_buffer_pool_size = 1G innodb_additional_mem_pool_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 3

Stripping cookies in Varnish

Posted by agoel@axelerant.com on October 5, 2010 at 1:16pm

We are using the Varnish/Pressflow stack for a large customer and running into some issues where visitors are being passed through Varnish. Upon closer inspection we are seeing all sorts of cookies that I cannot find in code.

MySQL table_cache: Is lower better?

Posted by Lloyd on October 4, 2010 at 7:37pm

In the past, using MySQL tuning scripts like mysqltuner.pl and tuning-primer.sh have always suggested increasing table_cache to fairly high levels. I've now been reading a few articles about benchmarks that have suggested a lower table_cache can often result in better performance (one such blog post at http://www.mysqlperformanceblog.com/2009/11/16/table_cache-negative-scal...).

So I was wondering what experiences people have had running Drupal sites in terms of tweaking table_cache.

Acquia Webinar: Performance Intelligence for Enterprise Drupal

Posted by Amazon on September 30, 2010 at 12:26pm

Start:

2010-09-30 13:00 - 14:00 America/New_York

Event type:

Training (free or commercial)

Drupal has proven to be a high-performance, high-scalability content management platform. Success deploying and managing enterprise-class Drupal implementations requires the same best practices and careful attention to detail as any large-scale project.

MySQL Tuning: tmp_table_size and max_heap_table_size

Posted by Lloyd on September 29, 2010 at 9:11pm

I'm switching over to a new server for my Drupal sites and am starting to tweak MySQL using tuning-primer and mysqltuner. I'm hosting on a VE server at Media Temple with (currently) 1GB of dedicated RAM. The database is currently MyISAM with no INNODB.

4Go DB with 157 302 nodes

Posted by edubuc on September 28, 2010 at 10:22pm

Hi,

I've a huge (4Go) database with 157 302 nodes and more than 1.5 million comments when the views module try to execute the query below it takes 22s to MySQL to return the result, do you have any MySQL or Drupal trick to help me reduce this time? (without using drupal cache)

I'm running this website on a Intel Xeon Quad Core 3220/3330 dedicated server with 8go of memory

SELECT DISTINCT node.nid AS nid,
votingapi_cache_node_points_vote_positives.value AS votingapi_cache_node_points_vote_positives_value,
node.created AS node_created,
users.picture AS users_picture,

Scaling Drupal on shared hosting

Posted by zfactor on September 28, 2010 at 4:02pm

Hi folks,

A client of ours just migrated their Drupal site to a shared hosting service and now experiencing performance issues with logged in users. Drupal's caching and APC are enabled, so content is loading fine for anonymous users. We are mostly running into issues with node add forms and administrative pages loading very slowly.

Has anyone run into similar issues migrating a site from a dedicated server to shared hosting? How did you improve performance on your site?

Performance, Aggreation, Private download, Caching, Node acces... Need advice

Posted by leilyrken on September 26, 2010 at 10:38am

Hi all,

My Drupal website is running very slow and we just wake up to trying to optimize the performance. I read a lot of thing about performance and caching system before and my main reason to post here is that I'm a bit confuse so I need some advice to find the best way to increase the perfomance of my site.

Maybe my post will also help high perfomance beginner.

First my website is:
- around 130 modules enabled (50 custom modules + cck, views, ctools, panels + different front end and back en modules)

Subscribe with RSS