performance

Since having attended DrupalCon Chicago (and really well before) we have tried to absorb as much as we could from the advice of the performance community and implement it.

We haven't yet implemented Varnish/memcache/apc..., but we would like to take this (varnish) as our next step. Memory is a bit of a concern for us, we have a handful of services all running on one 8GB machine with a fair amount of daily traffic. I aplogize for the loads of data ahead, but i figured better to write too much rather than not enough.

We are primarily concerned with,

I recently (yesterday) got my hands dirty with a huge news-site in Greece that suffers from really bad performance!

I checked the filesystem and saw that the previous admins placed all files under the "sites/default/files" folder, without creating subdirectories. Now there are more than 20000 files under there, increasing by 100 per day.

Could this be the source of all evil? The owners of the site say that the problems are getting worse every month so I imagined that by re-arranging files in the file-system I would gain something in performance.

Thanks for the linode VPS tutorial on how to install mercury, I'm pretty sure I'd be flailing about biting my toenails had I not found it. But before I go ahead and install and configure it, I can't seem to figure out whether mercury is what I'd be needing because most of my users will be authenticated users.

From what it sounds like, varnish+pressflow+awesomesauce=Mercury and that is best for boatloads of anonymous users. So my question is what kind of performance gain would I get if I install mercury running a site built for authenticated users?

Hello,

I'm about to move from development to launch on a project that uses solr to index around 800,000 nodes. At present it is on a dedicated server with 4gb ram, along with about 15 other websites I host. It is clear that under load I am experiencing slow downs in mySQL from a lack of memory, and from what I've read it appears the RAM allocated to Solr is a major factor in how fast and responsive your solr searches are.

What I'd like to know is

• Should I be aiming to upgrade this server with more memory, or to launch a new box that is dedicated to mysql/solr/both?

I am running tuning-primer.sh and mysqltuner.pl

mysqltuner.pl says:
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Adjust your join queries to always utilize indexes
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
join_buffer_size (> 128.0K, or always use indexes with joins)
tmp_table_size (> 50M)
max_heap_table_size (> 50M)

I need help determining if we can really use Drupal and MySQL for a new site being planned for the Special Olympics of Northern California. I just read through another thread here by a "novice" and that "novice" knows WAY more than I do, so please know that while I'm a good Drupal designer, I know NOTHING about real performance issues.

The Special Olympics has a limited budget and I, nor anyone, will be setting up and managing the server configuration. We are looking at commercial hosts like GoDaddy.com and I'd like to use GoDaddy if it's not ridiculous for our needs.

I've tried to go through the groups and forums to glean as much information as I could prior to posting this. I fall into the category of someone who is fairly familiar with drupal and mildly familiar with server setups. There is a wealth information on Performance and tuning, but it leaves the novice without a clear path of how to scale. I though I would post my setup here along with my confusion, in hopes that it will help other individuals in the same boat.

My Current Setup
I currently have 400K nodes and 100 users
I hope to be able to scale to 100k + users 5M Nodes

Hello everyone,

I've just had a debate on the issue queue for core about Fast 404s and how to route around the issue of having Drupal be the 404 handler by default. The debate was enlightening for everyone involved I think. But the consequence should be a documentation page addressing the issue and the multiples available strategies for solving it.

Propeople is organizing a "Drupal Thursdays" meetings in order to share our advanced Drupal knowledge with Drupal developers and anyone interested in Drupal.

Every Thursday evening invite you to join our team for discussion on various topics about Drupal.

Start time: 19:30
Location: Sofia, Pirin 40A street

The topic will be “Reverse proxy basics". Rumen Yordanov, the Head of Open Source Department, will explain how the reverse proxy works and why is the pros and cos of using it.

Hello,

I'm looking for a forum solution for a Drupal site. This forum must support moderating. Is there any lightweight solution, or is the forum access module scalable? Last year I had problem with a node access module. Is it correct that Forum Access sustains the same issue?

Do you know any big forum (a few dozens of thousands of nodes or more) that uses the Drupal forum?

Thanks.